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 againrgds

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.

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History