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
(;).



Sakis wrote:

Thank you also but it does not work....
--
Thank You!!!

"Dave Peterson" wrote:

One way:

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

Sakis wrote:

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(AK880,001),"ecxellent"))

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

Any idea how can I do this?
--
Thank You!!!

--

Dave Peterson


--

Dave Peterson