I am trying to use an IF
function in a formula in MS Excel 2013, but every time the IF
function ignores the condition I wrote and goes to the true value. I checked my IF
statement over and over, and I don't see anything weird or wrong.
This is the equation I used:
=IF(F17>0,(ABS(D17)/100*G16)+G16,(G16-((ABS(D17)/100)*G16)))
First, it checks the value of F
column to see if it's larger or smaller than 0
, then it does some math based on the IF
being true or false.
The problem is that it always calculates the true value even if the F17
contains a negative number.
F17
references the cellF17
, not the entire column.=IF(F17>0,"F17 > 0","F17 < 0")
and it worked as intended. The actual formula switched positive/negative when true/false.