USE IF CONDITION FOR 2DATA

  • Thread starter Thread starter deen
  • Start date Start date
D

deen

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<12>6,"GOLD",
IF(A2>=5,IF(B2<=6,"SILVER")))

PLS DO THE NEEDFUL

REGARDS,

DEEN
 
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<12>6),"GOLD",IF(AND(A2>=5,B2<=6),"SILVER")))

Regards,
Paul
 
Hi

Is it
=IF(A2>=12,"PLA",IF(AND(A2>10,B2>6),"GOLD",IF(AND(A2>=5,B2<6),"SILVER","")))
 
THX a LOT,

i have more doubt Mr.paul,

i have data like ,

A B C Result
(Tot) (month) (A/c)

12 12 10 PLA

11 7 20 GOLD

6 5 30 GOLD

i need formula like a,


=IF(B2>=12,=B2/=C2),"PLA","GOLD"

PLS DO THE NEED FUL,

REGARDS,
DEEN
 
THX a LOT,

i have more doubt Mr.paul,

i have data like ,

A B C Result
(Tot) (month) (A/c)

12 12 10 1.2


i need formula like a,

=IF(B2>=12,=B2/=C2),

PLS DO THE NEED FUL,

REGARDS,
DEEN
Click to expand...
 
deen said:
HI FRIENDS

I NEE A FORMULA LIKE,

=IF(AND(B2>=10,B2/C2),IF(AND(b2<10,b2*c2,"")))

PLS DO ME A FAVOUR
Click to expand...

Try this:

=IF(B2="","",IF(B2>=10,B2/C2,B2*C2))

Biff
 
Back
Top