IF function with simple muliplication not working...

[dougan]

I´ve been trying to get the following to work in excel:
Rules are:

IF
E10<30 THEN E22==0
IF
E10>=91 BUT E10<=180 THEN E22=(L24*7)
IF
E10>=181 BUT E10<=364 THEN E22=(L24*15)
IF
E10>=365 THEN E22=(L24*30)

In the following formulation:
=IF(E10<90, E22==0,IF((E10>=91 AND(E10<=180)), L24*7),), IF(E10>=181 OR IF(E10<=364, L24*15) IF(E10>=365, L24*30)
but guess what....
DENIED!

Can you help me out? I´m starting to tear my hair off!!
BIG THANKS!!!

 

[bbott]

Hi and welcome to the board,

What is the result if E10 is between 30 and 90?

 

[bbott]

I have the value between 30 and 90 set to L24 for now. This should work:

=IF(E10 < 3 0,0,IF(AND(E10 >= 31,E10 <= 90),L24,IF(AND(E10 >= 91,E10 <= 180),L24*7,IF(AND(E10 >= 181,E10 <= 364),L24*15,IF(E10 >= 365,L24*30,"")))))

 

[dougan]

you sir are a GOD

I've been trying to do this for the last THREE DAYS with obviously (and sadly) no results.... THANK THANK THANK YOU!!! ray:ray:ray:

(btw the value between 30 and 90 was L24*3.75, I forgot to specify it)