Complicate function

[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?

 

[Stephen]

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?

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

 

[Dave Peterson]

One way:

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

 

[Sakis]

Thank you for you responce but actually it is not working.....

 

[Sakis]

Thank you also but it does not work....

 

[Stephen]

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

 

[Sakis]

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

Thanks again

 

[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....

 

[Peo Sjoblom]

What error is that?


--


Regards,


Peo Sjoblom

 

[Sakis]

That was I had to change the commas....
Thanks a lot!!!!!!
Great support!!!