writing a formula containing if and and

N

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
 
F

Frank Kabel

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

Matt - Data Manager - Blue Ridge Telecom

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

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"
 
Top