Formula Help

[Solved/Closed]
Report
Posts
2
Registration date
Wednesday April 17, 2013
Status
Member
Last seen
April 18, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
Hello,

I think this is a simple question just not for me :)

I have a simple business spreadsheet showing total project cost in Column (C.) C, Tax in C.-D, Cost in C.-F and Profit in C.-G. For tax exempt customers I put N/A in C.-D representing no tax required. What formula do I use for Profit that subtracts the Tax when there is a number and counts the tax as 0 when it has a N/A. I don't want to simply put a 0 in the Tax if they are tax exempt because it may look like I didn't collect it vs. being exempt. That's why I am using N/A.

Thank you for any help you may provide.

3 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
Hi sjefferys,

From you description I understand that you receive "#VALUE!" in cells in "Profit" Column (Column G) when there is "N/A" in "Tax" Column (Column D). If this is the case use the following formula in "Profit" Column (Column G):

=IFERROR((C2-F2),(C2-D2-F2))

Instead of (C2-F2) and (C2-D2-F2) you can use you actual formula for calculating "Profit".

Do reply with results.
Posts
2
Registration date
Wednesday April 17, 2013
Status
Member
Last seen
April 18, 2013

I tried this and still got the "#VALUE!" so I reversed the formula and it worked. Thank you very much!
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
Hi sjefferys,

I am glad to know the formula worked for you (of course, with changes made by you). Please feel free to contact us if you need any further assistance.