If Statement XP Version

  • Thread starter Thread starter jmanrev
  • Start date Start date
J

jmanrev

Hello All,

I would first like to thank you for your time to help answer my
question.

I am using office xp and i am editing a file used in excel 97. The
file is a very simple accounts receiveable spreadsheet. Because I live
on the border of 2 states and do business in both I have to pay sales
taxes. No big deal. What i want tho is in my spread sheet to put in an
if statment that will based on wether or not WV is put in or OH these
can be subtituded with a 1 or 2. If it is WV or 1 in the cell d9 then
take what i recieved in e9 divide it and give back two numbers one in
f9 my money and k9 or l9(depending on if oh or wv) two sales taxes, and
if d9=oh then give the same thing but times a different sales tax i
know i can use a absolute reference to help with pointing out the sales
taxes for each state but how can i get it to do the rest for me.

=if(d9=wv,,if d9=oh,,))
 
=IF(StateCell=WV,Amount*WVTax,IF(StateCell=OH,Amount*OHTax
where you have a cell with an amount and 2 named cells (OHTax and WVTax)
with the appropriate tax rate
 
But how can i get it to put the value in 2 different columns so i can
total the taxes for each state and know how much to send them i think
the two sugestion would work for input to be in the same column but i
would like to be able to put in the WV column how much if false but in
the ohio column

Thank you
 
how about?
in one column
=if(d9="wv",.085,"")
in another column
=if(d9="OH",.075,"")
 
The last entry from Don Helped i can get it to calulate that.

thank you

thank you

thank yo
 
Back
Top