Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF function???
Hello there,
I am hoping someone can help! I am producing a spreadsheet that will allocate a Red / Amber / Green status based on target hit. The guideline is Green - on target Amber - within 95% of target (either above or below target) Red - more than or less than 95% of target ie where the target is 82% A1 B2 C2 Actual Target Status IF the actual is 82% then the status is Green IF the actual is greater than or equal to 77.9% (95% of target) it is Amber IF the actual is less than or equal to 86.3% (95% of target) it is Amber IF the actual is less than 77.9% (95% of target) it is Red IF the actual is greater than 86.3% (95% of target) it is Red Or written with references: A1 B2 C2 Actual 82% Formula needed!!! IF A1 = B2 then C2 = "Green" IF A1 = B2 * 95% then C2 = "Amber" IF A1 <= B2 / 95% then C2 = "Amber" IF A1 < B2 * 95% then C2 = "Red" IF A1 B2 / 95% then C2 = "Red" Many thanks in advance to anyone who can help! Cheers, Worzell |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF function???
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF function???
Thats great - thank you!!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested If Function | Excel Worksheet Functions | |||
can you nested sum and round function within if function? | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Nested If function? | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |