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
|