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.
Best Answer
Troubleshoot the formula step by step. Start with a simple
=IF(F1>0,TRUE,FALSE)
and copy down. If the result shows TRUE for all rows, then your source data is the problem. You may have text that looks like numbers.