Solved: check range of numbers conditionnaly

[mehdoush]

hey guys,

i'm lookin' for a way how to write a vba lines which help do like so :


if i write a number between 1 and 10 next cell displays "Good"
if i write a number between 11 and 20 next cell displays "Very Good"

if i write a number between 21 and 30 next cell displays "Excellent"

thanks in advance for help
regards

[mikerickson]

The formula
=IF(A1<1,"",IF(A1<11,"Good",IF(A1<21,"Very Good",IF(A1<31,"Excellent","Extremely Excellent")))) should do what you want.

[mehdoush]

thanks a lot, but plz tell me where i put ";" excel demands this

[Aussiebear]

We will need more information to assist in this ";" issue?

[mehdoush]

thnks it's no longer an issue
here's it

"=If(A1<1;"";If(A1<11;"GOOD";If(A1<21;"very good";If(A1<31;"excellent";"Extremely Excellent")))) "

[Aussiebear]

Just change the ";" for a ","