USE IF CONDITION FOR 2DATA
What is your formula supposed to do?
This combines some of your functions
=IF(AND(A2=12,B2<=12),"PLA",IF(AND(A2=10,B2<126 ),"GOLD",IF(AND(A2=5,B2<=6),"SILVER")))
Regards,
Paul
"deen" wrote in message
ups.com...
HI,
In excel sheet we have data like ,
A B C
(Avg) (Month) (Result)
12 12 PLA
11 7 GOLD
6 5 SILVER
formula need like,
IF(A2=12,IF(B2<=12,"PLA",IF(A2=10,IF(B2<126,"GO LD",
IF(A2=5,IF(B2<=6,"SILVER")))
PLS DO THE NEEDFUL
REGARDS,
DEEN
|