Here's a juicy one for you (IFs, ANDs, ISERRORs and SUMs)

[HugoRune]

Hi guys,

Wondering why Excel is giving me a result for the following formula.

=IF(AND(G139>0.194,H139>0.744),"A",IF(SUM(G139+H139)>0.744,"B",IF(SUM(G139+H139+I139)>0.894,"C",IF(AND(G139="",H139="",I139="",J139=""),"","D"))))

In the above example despite cells G139, H139, I139 and J139 being blank it still returns a value of "A"

I think it may have something to do with these cells containing another formula {=IF(ISERROR(SUM(B139/$F139)),"",SUM(B139/$F139))} which returns the blank value.

Is this a Microsoft Programming "Feature" aka "bug"? and is there any way around it?

Hope you can help

Cheers

 

[gsbelbin]

If you use Evaluate Formula you'll see that both G139>0.194 and H139>0.744 are returning TRUE even though "" is in both cells. Indeed if you enter ="">1 in a cell it will return TRUE. Not a problem I've encountered before. Anyone else??