Returning text after a specific value is computed

[ddennis]

Good day to all:

I have created a spreadsheet that computes GPA's. It works great. I would like specific text returned in a cell when GPA's is in a certain range.

Here are the parameters: GPA of 3.2 returns "cum laude"
GPA of 3.5 returns "magna cum laude"
GPA of 3.8 returns "summa cum laude"

I am not a programmer, any help is greatly appreciated.

Regards,

Dion

 

[SteveO59L]

How about a nested If statement, something like

if("source cell"=3.2,"cum laude",if("source cell"=3.5,"magna cum laude",if("source cell"=3.8,"summa cum laude"," ")))

 

[Zack Barresse]

Hi Dion,

You could get this w/ a single formula or set up a table and reference it; or do it with VBA code.

A single formula might look like (w/o seeing your data)...

=IF(A1>=3.2,"cum laude",IF(A1>=3.5,"magna cum lade",IF(A1>=3.8,"summa cum lade",IF(A1>4.0,"Out of Range"))))

 

[onlyadrafter]

Hello,

Try

=IF(A1=3.2,"cum laude",IF(A1=3.5,"magna cum laude",IF(A1=3.8,"summa cum laude","VALUE NOT RECOGNISED")))

 

[Aladin Akyurek]

Can't hurt to pick up a more efficient idiom for this kind of 'if' situations...

=LOOKUP(A1,{0,"";3.2,"cum laude";3.5,"magna cum laude";3.8,"summa cum laude"})

where A1 houses a GPA value.

 

[Met Fan]

Try this Dion

=IF(A1>=3.8,"Summa Cum Laude",IF(a1.=3.5, "Magna Cum Laude", IF(A1>=3.2,"Cum Laude","")))

This will return a blank if the GPA is less than 3.2

 

[ddennis]

Dear All:

Many, many thanks!

You folks sure are wizards..all the best,

Dion