Formula with a text result

  • Thread starter Thread starter Sami66
  • Start date Start date
S

Sami66

I am doing a worksheet on grades.

Column F is titled "Status"

Column E has students' averages

I need a formula that shows that if the average is above 80, then
need text that says "Doing Well" to appear.

If below 80, I need text that says "Study More"

Please help asap!!!!!

Thanks in advance!!
 
Hi Sami,

Suppose a given student's average is in E2. In that case, F2 could have the
formula:
=IF(E2<80,"Study More", "Doing Well")
You don't say what to do if the score is 80, so I'm assuming that 80 and
above equates to "Doing Well". If not, try:
=IF(E2>80,"Doing Well","Study More")

Copy the formula down from F2 to whatever your last row is.

Cheers
PS: If the 80 is really 80%, change the 80 to 80% in the above formulae.
 
Back
Top