Re: Digest for excelfiles_india@googlegroups.com - 4 Messages in 1 Topic

4 views
Skip to first unread message

G. Ram

unread,
Dec 9, 2009, 2:22:18 AM12/9/09
to excelfil...@googlegroups.com
sir,
  I have sent a attachment. please help me..
 

On Wed, Dec 9, 2009 at 8:21 AM, <excelfil...@googlegroups.com> wrote:
  Today's Topic Summary

Group: http://groups.google.com/group/excelfiles_india/topics

    "G. Ram" <grs...@gmail.com> Dec 08 02:51PM +0530
     
    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

     

    Dilip Pandey <dilip...@gmail.com> Dec 08 03:08PM +0530
     
    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 <kart...@gmail.com> Dec 08 06:15AM -0800
     
    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
    -------------------------
    >=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

     

--

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.

Book2.xls

G. Ram

unread,
Dec 11, 2009, 12:20:33 AM12/11/09
to Sixth Sense, excelfil...@googlegroups.com
?ui=2&view=att&th=1257c2ccaf4fafd9&attid=0.1&disp=attd&realattid=ii_1257c2ccaf4fafd9&zw

Mr.sixth sense and all other members of this groups..

regards,
Ram,




On Thu, Dec 10, 2009 at 10:50 PM, Sixth Sense <sixths...@gmail.com> wrote:
Ram here I have attached the corrected file for your reference.

The problem is you have formatted the numbers as %.  So it will take it as 40*100 so if you give the formula as 40 85 90 95 100 then all will result as Worst only.

Now i have formatted it with a custom function ##.##"%".  If you dont want to see the decimal values the format it as ##"%"

There was unnecessary * marks in your if formula the same was cleared.

Finally I have added another If function for the criteria if the value is greater than 95 and less than 100 as GOOD.

--
Your Friend

Sixthsense
thank you .png

Sixth Sense

unread,
Dec 10, 2009, 12:20:59 PM12/10/09
to excelfil...@googlegroups.com
Ram here I have attached the corrected file for your reference.

The problem is you have formatted the numbers as %.  So it will take it as 40*100 so if you give the formula as 40 85 90 95 100 then all will result as Worst only.

Now i have formatted it with a custom function ##.##"%".  If you dont want to see the decimal values the format it as ##"%"

There was unnecessary * marks in your if formula the same was cleared.

Finally I have added another If function for the criteria if the value is greater than 95 and less than 100 as GOOD.

--
Your Friend

Sixthsense

On Wed, Dec 9, 2009 at 12:52 PM, G. Ram <grs...@gmail.com> wrote:
Ram-Final.xls
Reply all
Reply to author
Forward
0 new messages