| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement
I trying to check is our performance is met on a monthly basis, we promise
the following: 95% target <95% & 90% below target <90% unacceptable I have the following forumala but cannot get the unacceptable to populate when we are below the 90% C6 = 95% D6 = 90% J6 = is our actual performance =IF(I6=0," ",(IF(J6=C6,"Target",IF(J6<C6&J6D6,"Below Target","Unacceptable")))) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement
jen-chi wrote:
I trying to check is our performance is met on a monthly basis, we promise the following: 95% target <95% & 90% below target <90% unacceptable I have the following forumala but cannot get the unacceptable to populate when we are below the 90% C6 = 95% D6 = 90% J6 = is our actual performance =IF(I6=0," ",(IF(J6=C6,"Target",IF(J6<C6&J6D6,"Below Target","Unacceptable")))) =IF(I6=0," ",IF(J6=C6,"Target",IF(J6=D6,"Below Target","Unacceptable"))) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement
Thanks, worked perfectly!!!!!
"Glenn" wrote: jen-chi wrote: I trying to check is our performance is met on a monthly basis, we promise the following: 95% target <95% & 90% below target <90% unacceptable I have the following forumala but cannot get the unacceptable to populate when we are below the 90% C6 = 95% D6 = 90% J6 = is our actual performance =IF(I6=0," ",(IF(J6=C6,"Target",IF(J6<C6&J6D6,"Below Target","Unacceptable")))) =IF(I6=0," ",IF(J6=C6,"Target",IF(J6=D6,"Below Target","Unacceptable"))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
Linear Mode
