Thread: I want my formula to result in zero if referenced cell = 0, otherwise calculate
View Single Post
 
Old 12-21-2022, 09:33 AM
Daronovitz Daronovitz is offline Windows 10 Office 2019
Novice
  
Join Date: Jul 2022
Posts: 13
Daronovitz is on a distinguished road
Default I want my formula to result in zero if referenced cell = 0, otherwise calculate
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.
Reply With Quote