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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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