Need Conditional Formula Solution - Help!

[rdusseau]

I think I have a rather easy question, but I just can't figure it out.

I have a list of scores (1-100) and I need to return three possible results. For example... if the score is greater that 80 I need to return the word 'Algebra', if the score is between 45 and 79 the word 'Pre-Algebra', and if lower that 45 the word "Concepts'.

Any thoughts... I really think this shouldn't be that hard but I just can't figure it out.

Thanks!
Rob

[Domenic]

Try the following...

=IF(A1<>"",IF(A1<=45,"Concepts",IF(A1<=80,"Pre-Algebra","Algebra")),"")

Adjust the brackets for your criteria accordingly (your post wasn't too clear).

Hope this helps!

I think I have a rather easy question, but I just can't figure it out.

I have a list of scores (1-100) and I need to return three possible results. For example... if the score is greater that 80 I need to return the word 'Algebra', if the score is between 45 and 79 the word 'Pre-Algebra', and if lower that 45 the word "Concepts'.

Any thoughts... I really think this shouldn't be that hard but I just can't figure it out.

Thanks!
Rob

[rdusseau]

That worked like a charm... thanks!

ROb