|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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) |
#3
|
|||
|
|||
Thank you for your help! Much appreciated!
|
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 |
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 |