Mulitple if function

[jamalhakem]

Hi
I have this problem
I have many conditions for if function
In C9 I have either “ok” or “not ok, if it is “ok” the cell h11 that
should be equal or greater than either 12, and if “not ok” the cell
h11 should be equal or greater than 9
I used (if) function and (and) function to check that if c9 is ok and
h11 is equal or greater than 12, then the result should be either =h11
or “bad”, but I can use if function to check if it is “not ok” and h11
equal or greater than 9, in the same formulae, is that possible to use
2 if functions in one formulae? Any help
if(and(C9="not
ok";and('H11>=9;H11;if(and(C9="ok";and(H11>=12;H11;"bad")))))
The message is too many arguments
Thanks in advance
Jam

 

[muddan madhu]

Try this

=IF((C9="ok")*(H11>=12),H11,IF((C9="not ok")*(H11>=9),H11,"bad"))

 

[Bob Phillips]

=IF(C9="ok",IF(H11>=12,H11,"bad"),IF(H11>=9,H11,"bad"))

--
__________________________________
HTH

Bob

Hi
I have this problem
I have many conditions for if function
In C9 I have either “ok” or “not ok, if it is “ok” the cell h11 that
should be equal or greater than either 12, and if “not ok” the cell
h11 should be equal or greater than 9
I used (if) function and (and) function to check that if c9 is ok and
h11 is equal or greater than 12, then the result should be either =h11
or “bad”, but I can use if function to check if it is “not ok” and h11
equal or greater than 9, in the same formulae, is that possible to use
2 if functions in one formulae? Any help
if(and(C9="not
ok";and('H11>=9;H11;if(and(C9="ok";and(H11>=12;H11;"bad")))))
The message is too many arguments
Thanks in advance
Jam