Formula HelpSolved/Closed

Question

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.
Configuration: Windows 8 / Internet Explorer 10.0

Zohaib R · Answer

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.

sjefferys · Answer

I tried this and still got the "#VALUE!" so I reversed the formula and it worked.  Thank you very much!

Zohaib R · Answer

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.

Formula Help

3 responses

Similar discussions

Subscribe To Our Newsletter!