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