writing a formula containing if and and

[nina]

Can someone help me write a logical formula that has
nested "if" functions with an "and" function thrown in?
Should be easy but I'm not getting the results I expect.
Would be willing to pay for consulting.

Thanks

 

[Frank Kabel]

Hi
=IF(AND(A1=1,B1=1),"A1+B1 equal 1",IF(A1>1,"A1 larger than
one","something else"))

 

[Guest]

Frank,
I just like to point out that If A1 = 1 and B1=1 then A1+B1 should equal 2
right?

 

[Frank Kabel]

lol
of course but I just wantedt to say that A1 AND B1 both are equal to
'1'

--
Regards
Frank Kabel
Frankfurt, Germany

"Matt - Data Manager - Blue Ridge Telecom"