View Single Post
stomachmonkey stomachmonkey is offline
The Unsettler
 
stomachmonkey's Avatar
 
Join Date: Dec 2002
Location: Lantanna TX
Posts: 23,885
Send a message via AIM to stomachmonkey
Quick excel help needed

Need an IF THEN OR formula for excel.

I need to calculate sales tax for 3 specific states, but not the other 47, that will be identified as NY, SC, OH so I need a formual that says "if (cell x) = NY then calculate sales tax based on the total amount column (cell y), else = 0

Make sense?

THX,
SCOTT
__________________
"I want my two dollars"
"Goodbye and thanks for the fish"
"Proud Member and Supporter of the YWL"
"Brandon Won"
Old 01-30-2007, 06:15 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #1 (permalink)