Someone must have asked this before but I can't find it!

T

turkishjim

Being a relative Excel newcomer I,m not sure of all the terminology so
may have used the wrong terms when searching. What I am trying to do is
create a worksheet in which a cell shows one of 3 values (LOW,AVERAGE
or HIGH) according to the value in the cell to the left of it, which
itself is the sum of the 2 preceding cells.
To be more specific, cell D6 is Men, E6 is Women and F6
is"=SUM(D6,E6)". I then want G6 to show "LOW" if F6 is less than 5,
"AVERAGE" if it is between 5 and 20, and "HIGH" if it is over 20.
If anyone understands the question and can help, I'd be very grateful.
Thanks in advance.
 
B

Bob Phillips

In G6

=IF(F6>=20,"HIGH",IF(F6>=5,"AVERAGE","LOW"))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
P

Paul Sheppard

Being a relative Excel newcomer I,m not sure of all the terminology so
may have used the wrong terms when searching. What I am trying to d
is
create a worksheet in which a cell shows one of 3 values (LOW,AVERAGE
or HIGH) according to the value in the cell to the left of it, which
itself is the sum of the 2 preceding cells.
To be more specific, cell D6 is Men, E6 is Women and F6
is"=SUM(D6,E6)". I then want G6 to show "LOW" if F6 is less than 5,
"AVERAGE" if it is between 5 and 20, and "HIGH" if it is over 20.
If anyone understands the question and can help, I'd be very grateful.
Thanks in advance.
Click to expand...

Hi turkishjim

Assuming your first data is in row 7, then in G6 enter this formula -

=IF(F7<5,"Low",IF(F7>20,"High","Average")), this will return Low if th
result is anything up to 4.99999..............., Average if the resul
is anything from 5 to 20.99999................. and High for anythin
from 21 u
 
Top