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.