I want my formula to result in zero if referenced cell = 0, otherwise calculate

Daronovitz · #1 12-21-2022, 09:33 AM

I have a formula to calculate Mortgage tax that goes like this:

=((V2-2000)*1.15)/1000

If V2 was $8010.00 then the result of the formula would be $6.91

I want to edit the formula so that if V2=$0.00 then the result of the formula would be $0.00, instead of -$2.30 which is what it results in now.

To summarize, I need to edit the formula above to only calculate if V2 doesn't equal zer, if it equals zero I want the result to be zero.

p45cal · #2 12-21-2022, 11:10 AM

What you're asking for is:
=IF(V2>0,((V2-2000)*1.15)/1000,0)
but you probably want:
=IF(V2>2000,((V2-2000)*1.15)/1000,0)
or:
=MAX(0,((V3-2000)*1.15)/1000)

Daronovitz · #3 12-21-2022, 11:44 AM

Thank you for your help! Much appreciated!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filling a formula down a column where only one cell value referenced changes?	sakurasanta86	Excel	1	08-27-2018 03:23 AM
Display Formula in Once Cell, Result in Another	rspiet	Excel	5	06-05-2018 08:27 AM
Filling a formula down a column where only one cell value referenced changes?	takamaz	Excel	2	03-11-2018 08:56 AM
Formula result not displaying in cell (but f9 works)	nath1235	Excel	4	10-06-2017 12:42 PM
Show result of formula as a value in another cell	Steve_D	Excel	4	10-12-2014 07:38 PM