View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
q3pd q3pd is offline
external usenet poster
 
Posts: 7
Default Multiple nested If statements

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