Petty cash hell
 

Hi,
I am trying to get my spread sheet to work out tax only if it is
deductable. So one column is titled gross, one is titled net and one is
titled tax. I want to be able to type in the gross cost in the gross
column, if i pay tax on the item i want to put a "Y" in the tax column
(Yes tax has been paid) and then the net ammount would be
automatically calculated and put in the net column. If I put a "n" in
it (No tax has not been paid) then the net column stays the same as the
gross amount.

Can you help?


--
maisy1
------------------------------------------------------------------------
maisy1's Profile: http://www.excelforum.com/member.php...o&userid=37157
View this thread: http://www.excelforum.com/showthread...hreadid=568761

Petty cash hell
 

Something like

=IF(B2="N",A2,A2*10)

Change *10 to your tax amount

The reverse would be

=IF(B2="y",A2*10,A2)

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568761

Petty cash hell
 

Thank you so much for that - It not only worked, but also stopped me
from throwing the laptop across the room!! You are a star.


--
maisy1
------------------------------------------------------------------------
maisy1's Profile: http://www.excelforum.com/member.php...o&userid=37157
View this thread: http://www.excelforum.com/showthread...hreadid=568761