Complicate function

S

Sakis

Hi,

Could someone please help me with the below function?

IF(AK8<30),"fair",
IF(30,001<AK8<60),"good",
IF(60,001<AK8<80),"very good",
IF(AK8>80,001),"ecxellent"))

I need this to become a function in one cell....

Any idea how can I do this?
 
S

Stephen

Sakis said:
Hi,

Could someone please help me with the below function?

IF(AK8<30),"fair",
IF(30,001<AK8<60),"good",
IF(60,001<AK8<80),"very good",
IF(AK8>80,001),"ecxellent"))

I need this to become a function in one cell....

Any idea how can I do this?
Click to expand...

Try this:
=IF(AK8>80,"excellent",IF(AK8>60,"very good",IF(AK8>30,"good","fair")))
 
D

Dave Peterson

One way:

=if(ak8<30,"fair",if(ak8<60,"good",if(ak8<80,"Very Good","Excellent")))
 
S

Stephen

What is it doing? Do you get an error? Do you just get the wrong selection?
Tell us!
 
S

Sakis

Yes, sorry,
the usual error comes up. The one that usually comes up when there is
mistake in any function!!

Thanks again
 
D

Dave Peterson

What's in ak8?
What did you expect and what did the formula return?

If you're not in the USA, you may have to replace the commas (,) with semicolons
(;).


Thank you also but it does not work....
Click to expand...
 
Top