View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sakis Sakis is offline
external usenet poster
 
Posts: 5
Default Complicate function

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")))