|
Registered
Join Date: Jul 2002
Location: Just East of Atlanta
Posts: 2,074
|
= IF(logical test, value if true, value if false)
EDIT:
I'm thinking, =IF(OR(NY,SC,OH),(taxrate*total amt), 0)
you can just use the cell definition for the taxrate i.e. B4 and the cell definition fr the total i.e. G7.
I did something similar, and it worked pretty well.
sjd
__________________
Porsche sold, moving back to muscle cars for a bit.
Last edited by atlporsche; 01-30-2007 at 06:41 PM..
|