Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In 'column a' I have cells with numbers ranging from 0 to 10.
In 'column b' I have cells with values ranging from 0% to 55%. In 'column c' I have cells with numbers ranging from 0 to 10. In 'column d' I have cells with values ranging from 0% to 34%. In 'column e' I have cells with values ranging from 0% to 76%. I require a function that returns 'Reaudit' when either 'column b', 'column d' or 'column e' cells are greater than 15%: or if 'column a' or 'column c' are greater than 2. If none of these are True it should return 'Follow-up'. If all five columns were 0, it should return 'Pass'. Please can any one help? -- Q3PD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiple (nested) IF statements | Excel Worksheet Functions | |||
Nested IF statements | Excel Discussion (Misc queries) | |||
multiple nested IF statements | Excel Worksheet Functions | |||
Nested If/Then statements | Excel Worksheet Functions | |||
nested statements | New Users to Excel |