If statements nested

[googley]

Need some expert help on the following, Thanks in advance for your assistance.


The first part of my formula works when H25 is <28 but it returns false when I change H25 to a number greater than 28

=IF(H25<28,IF(K25=50,6,IF(K25=100,8,IF(H25>28,IF(K25=80,10,IF(K25=150,10))))))

 

[Claus Busch]

Hi,

Am Wed, 30 Oct 2013 18:22:39 -0700 (PDT) schrieb googley:

=IF(H25<28,IF(K25=50,6,IF(K25=100,8,IF(H25>28,IF(K25=80,10,IF(K25=150,10))))))

try:
=IF(AND(H25<28,K25=50),6,IF(AND(H25<28,K25=100),8,IF(AND(OR(K25=80,K25=150),H25>28),10,"")))


Regards
Claus B.

 

[googley]

Need some expert help on the following, Thanks in advance for your assistance.





The first part of my formula works when H25 is <28 but it returns false when I change H25 to a number greater than 28



=IF(H25<28,IF(K25=50,6,IF(K25=100,8,IF(H25>28,IF(K25=80,10,IF(K25=150,10))))))