Hi

=IF(B2=12,=B2/=C2),
Try
=IF(B2=12,B2/C2,"")


--
Regards

Roger Govier


"deen" wrote in message
ups.com...
On Jun 16, 8:32 am, deen wrote:
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

On Jun 15, 8:30 pm, "PCLIVE" wrote:

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

oups.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