nesting formulas
 

I'm trying to get this formula to work.

=IF(OR(K2="L",K2="M",E2<=10),120,60,IF(OR(K2="L",K 2="M",E2=11,E2=12,E2=13,E2=14),90,60,IF(OR(K2="L", K2="M",E2=15,E2=16,E2=17),45,45,IF(OR(K2="L",K2="M ",K2="H",E217),30,30))))


But it tells me that I have too many arguements within the function.

The problem is they are required to get the answer I am looking for. What
I'm asking is: If column K has an L or M and column E is <=10, then the value
is 120, if false, 60. If in K, L and M are equal to 11 through 14 in column
E, then the value is 90 and if false 60, IF in column K, L and M are equal to
15-17 in column E then the answer is 45 and if not it is 45, and if in column
K, L and M are greater than 17 in column E, then the answer is 30 and if mot
it is 30.


Please Help

nesting formulas
 

Yeah you have too many arguments, starting with the first IF clause.

You're saying "If (K2 = L OR M) OR (E2 is less than or equal to 10), THEN
120, ELSE 60"

Then you have another IF clause....

Nested IFs have to work like =IF(Condition 1,Then Do X, Else If(Condition 2,
Then Do...)

See the difference?
--
Brevity is the soul of wit.


"Vladimir" wrote:

I'm trying to get this formula to work.

=IF(OR(K2="L",K2="M",E2<=10),120,60,IF(OR(K2="L",K 2="M",E2=11,E2=12,E2=13,E2=14),90,60,IF(OR(K2="L", K2="M",E2=15,E2=16,E2=17),45,45,IF(OR(K2="L",K2="M ",K2="H",E217),30,30))))


But it tells me that I have too many arguements within the function.

The problem is they are required to get the answer I am looking for. What
I'm asking is: If column K has an L or M and column E is <=10, then the value
is 120, if false, 60. If in K, L and M are equal to 11 through 14 in column
E, then the value is 90 and if false 60, IF in column K, L and M are equal to
15-17 in column E then the answer is 45 and if not it is 45, and if in column
K, L and M are greater than 17 in column E, then the answer is 30 and if mot
it is 30.


Please Help