please correct my formula..

[G. Ram]

Dear friends,
     
    is there any mistake in this formula?. i got error

 =IF(AND(M22>=100),"VERY GOOD",IF(AND(M22<=95)(M22>=90),"NOT BAD",IF(AND(M22<=89)(M22>=85),"BAD","WORST")))

please help me..

thanks & regards,
Ram

[Monu(Avtar Kishan Agarwal )]

=IF(AND(M22>=100),"VERY GOOD",IF(AND(M22<=95)*(M22>=90),"NOT BAD",IF(AND(M22<=89)*(M22>=85),"BAD","WORST")))

 

IT SHOULD BE LIKE THIS

 

Thanks & Regards

Monu (Avtar Kishan Agarwal),

Jodhpur General Suppliers,

Jodhpur,

9785434371

9785614215

 

---

--

You received this message because you are subscribed to the Google Groups "ExcelFiles_India" group.
To post to this group, send email to excelfil...@googlegroups.com.
To unsubscribe from this group, send email to excelfiles_ind...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/excelfiles_india?hl=en.

[Dilip Pandey]

Dear Ram,

 

Below is the corrected formula:-

 

=IF(M22>=100,"VERY GOOD",IF(AND(M22<=95,M22>=90),"NOT BAD",IF(AND(M22<=89,M22>=85),"BAD","WORST")))

You have included extra brackets for AND logic.

 

Best Regards,

--
DILIP KUMAR PANDEY  
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilip...@gmail.com
dilip...@yahoo.com
New Delhi - 110062

 

[Karthik Bhat]

Hi

Not sure why you have a gap between "Very Good" and "Not Bad". What
happens if M23 is between 95 and 100? Similarly what happens if the
value is 90.5?

You will have to spell out your exact requirement here. I am giving a
simpler solution assuming the following:
-------------------------
M23 Result
-------------------------
>=100 VERY GOOD
>=90 NOT BAD
>=85 BAD
Any other WORST
-------------------------

=IF(M23>=100,"VERY GOOD",IF(M23>=90,"NOT BAD",IF
(M23>=85,"BAD","WORST")))

If this is not what you require then you would have to give us a table
similar to the one I have above.

Thx
KB