View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Complicate function

What error is that?


--


Regards,


Peo Sjoblom



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

Thanks again
--
Thank You!!!


"Stephen" wrote:

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

"Sakis" wrote in message
...
Thank you for you responce but actually it is not working.....
--
Thank You!!!


"Stephen" wrote:

"Sakis" wrote in message
...
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!!!

Try this:
=IF(AK880,"excellent",IF(AK860,"very
good",IF(AK830,"good","fair")))