# Formula Help

Solved/Closed
sjefferys Posts 2 Registration date Wednesday April 17, 2013 Status Member Last seen April 18, 2013 - Apr 17, 2013 at 09:02 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 18, 2013 at 10:41 PM
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.

## 3 responses

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 18, 2013 at 03:49 AM
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".