View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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