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 thecell`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.2more comments