USE IF CONDITION FOR 2DATA
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
|