Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-21-2022, 09:33 AM
Daronovitz Daronovitz is offline I want my formula to result in zero if referenced cell = 0, otherwise calculate Windows 10 I want my formula to result in zero if referenced cell = 0, otherwise calculate Office 2019
Novice
I want my formula to result in zero if referenced cell = 0, otherwise calculate
 
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
  #2  
Old 12-21-2022, 11:10 AM
p45cal's Avatar
p45cal p45cal is offline I want my formula to result in zero if referenced cell = 0, otherwise calculate Windows 10 I want my formula to result in zero if referenced cell = 0, otherwise calculate Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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

Thank you for your help! Much appreciated!
Reply With Quote
Reply

Tags
formula, if then, reference

Thread Tools
Display Modes


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
I want my formula to result in zero if referenced cell = 0, otherwise calculate Filling a formula down a column where only one cell value referenced changes? takamaz Excel 2 03-11-2018 08:56 AM
I want my formula to result in zero if referenced cell = 0, otherwise calculate Formula result not displaying in cell (but f9 works) nath1235 Excel 4 10-06-2017 12:42 PM
I want my formula to result in zero if referenced cell = 0, otherwise calculate Show result of formula as a value in another cell Steve_D Excel 4 10-12-2014 07:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft