1 Attachment(s)

Problem with if <= formula not calculating correctly

Attachment 631922

Here is the formula that I am using

=IF(F4="","",IF(G4<=D4,"Approved","Not Approved"))

My problem is that the formula is always showing a true value even when it is not. The result in G4 is an absolute value. Not that that should affect but just thought I should say it.

Any help would be appreciated.

Thank you

Paul

Re: Problem with if <= formula not calculating correctly

It is difficult to debug from a picture/screenshot. A representative, anonymized sample file would be better.

That said, I notice that all of the values in column D have a little green triangle indicating some kind of error/warning associated with those cells/values. The first one I think of is "number stored as text". When it comes to "order", a text string is always "larger than" a number, so the text string "185.0" is larger than the number 186.5. The first thing I would do to debug this is to hover over the green triangle and see what error/warning is given. If it is "number stored as text", then the next step is to convert that column to real numbers (some strategies here: https://support.office.com/en-us/art...1-c5bad0f0a885 ).

Re: Problem with if <= formula not calculating correctly

may be the change this

the D4 to E4

PHP Code:

```
=IF(F4="","",IF(G4<=E4,"Approved","Not Approved"))
```

or

G4 to F4

PHP Code:

```
=IF(F4="","",IF(F4<=D4,"Approved","Not Approved"))
```