View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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