writing a formula containing if and and
 

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

writing a formula containing if and and
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"nina" schrieb im Newsbeitrag
...
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

writing a formula containing if and and
 

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


"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"nina" schrieb im Newsbeitrag
...
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

writing a formula containing if and and
 

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"
soft.com schrieb im
Newsbeitrag ...
Frank,
I just like to point out that If A1 = 1 and B1=1 then A1+B1 should
equal 2
right? :)


"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"nina" schrieb im Newsbeitrag
...
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