Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help writing a formula | Excel Discussion (Misc queries) | |||
writing a formula | Excel Worksheet Functions | |||
Need help with writing formula. | Excel Worksheet Functions | |||
Writing a Formula | Excel Discussion (Misc queries) | |||
Formula Writing | Excel Programming |