Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mulitple if function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mulitple if function
Try this
=IF((C9="ok")*(H11=12),H11,IF((C9="not ok")*(H11=9),H11,"bad")) On Sep 18, 7:47*am, wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mulitple if function
=IF(C9="ok",IF(H11=12,H11,"bad"),IF(H11=9,H11,"b ad"))
-- __________________________________ HTH Bob wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF Function with mulitple criteria? | Excel Worksheet Functions | |||
Mulitple formulas | Excel Discussion (Misc queries) | |||
Lookup function with mulitple conditions | Excel Worksheet Functions | |||
mulitple formulas | Excel Worksheet Functions | |||
Changes to Mulitple Worksheets | Excel Worksheet Functions |