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:
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.
F17references the cell
F17, 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.