IF formula in Excel

January 12, 2011 at 12:06:12
Specs: Windows Vista
hi,

i'm looking for a formula for below query

IF A1&A2=4 then on Cell A5 text has to be displayed as "V.Good", & IF A1&A2=3 on Cell A5 text has to be displayed as "Good" & IF A1=3 & A2=4 on Cell A5 text has to be displayed as "OK" else <3 on Cell A5 text has to be displayed as "poor"


let me know if my objective is not clear.
i'll explain again

rgds


See More: IF formula in Excel

Report •

#1
January 12, 2011 at 13:32:57
Look up Nested IF in the Excel Help files and/or on Google.

Look up the AND function in Excel Help files and/or on Google.

You are looking for something like this:

=IF(AND(A1=4, A2=4),"V. Good", IF(AND(A1=3, A2=3),"Good",IF( ....

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question