|
=IF(J2="ny",(19.99*0.0875),IF(J2="oh",(19.99*0.065),IF(J2="sc",(19.99*0.05))))
Change the 0.065 and 0.05 values for oh and sc (respectively) to whatever the correct numbers are.
Randy
__________________
84 944 - Alpine White
86 Carrera Targa - Guards Red - My Pelican Gallery - (Gone, but never forgotten  )
One Marine's View
Igitur qui desiderat pacem, praeparet bellum
|