| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula in spreadsheet
C1 is the sum of A1 and A2
How can I get C1 to remain empty unless there is a number in BOTH cells. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula in spreadsheet
=IF(OR(A1="",A2=""),"",A1+A2)
-- Gary''s Student gsnu200709 "Dennis1188" wrote: C1 is the sum of A1 and A2 How can I get C1 to remain empty unless there is a number in BOTH cells. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula in spreadsheet
Dennis, this should do it, =IF(OR(ISBLANK(A1),ISBLANK(A2)),"",A1+A2)
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Dennis1188" wrote in message ... C1 is the sum of A1 and A2 How can I get C1 to remain empty unless there is a number in BOTH cells. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula in spreadsheet
PERFECT!!!
Now let's try one other thing... I would like it to do the same thing if we put in the number 0 "Gary''s Student" wrote: =IF(OR(A1="",A2=""),"",A1+A2) -- Gary''s Student gsnu200709 "Dennis1188" wrote: C1 is the sum of A1 and A2 How can I get C1 to remain empty unless there is a number in BOTH cells. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula in spreadsheet
PERFECT!!!
Now let's try one other thing... I would like it to do the same thing if we put in the number 0 "Paul B" wrote: Dennis, this should do it, =IF(OR(ISBLANK(A1),ISBLANK(A2)),"",A1+A2) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Dennis1188" wrote in message ... C1 is the sum of A1 and A2 How can I get C1 to remain empty unless there is a number in BOTH cells. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula in spreadsheet
Dennis, If I understand you right, try this
=IF(OR(A1="",A2=""),"",IF(OR(A1<=0,A2<=0),"",A1+A2 )) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Dennis1188" wrote in message ... PERFECT!!! Now let's try one other thing... I would like it to do the same thing if we put in the number 0 "Paul B" wrote: Dennis, this should do it, =IF(OR(ISBLANK(A1),ISBLANK(A2)),"",A1+A2) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Dennis1188" wrote in message ... C1 is the sum of A1 and A2 How can I get C1 to remain empty unless there is a number in BOTH cells. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula in spreadsheet
THANK YOU!!!!!!!
"Paul B" wrote: Dennis, If I understand you right, try this =IF(OR(A1="",A2=""),"",IF(OR(A1<=0,A2<=0),"",A1+A2 )) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Dennis1188" wrote in message ... PERFECT!!! Now let's try one other thing... I would like it to do the same thing if we put in the number 0 "Paul B" wrote: Dennis, this should do it, =IF(OR(ISBLANK(A1),ISBLANK(A2)),"",A1+A2) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Dennis1188" wrote in message ... C1 is the sum of A1 and A2 How can I get C1 to remain empty unless there is a number in BOTH cells. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula in spreadsheet
=IF(OR(A1=0,A2=0),"",A1+A2)
-- Gary''s Student gsnu200709 "Dennis1188" wrote: PERFECT!!! Now let's try one other thing... I would like it to do the same thing if we put in the number 0 "Gary''s Student" wrote: =IF(OR(A1="",A2=""),"",A1+A2) -- Gary''s Student gsnu200709 "Dennis1188" wrote: C1 is the sum of A1 and A2 How can I get C1 to remain empty unless there is a number in BOTH cells. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula in spreadsheet
THANK YOU!!!
"Gary''s Student" wrote: =IF(OR(A1=0,A2=0),"",A1+A2) -- Gary''s Student gsnu200709 "Dennis1188" wrote: PERFECT!!! Now let's try one other thing... I would like it to do the same thing if we put in the number 0 "Gary''s Student" wrote: =IF(OR(A1="",A2=""),"",A1+A2) -- Gary''s Student gsnu200709 "Dennis1188" wrote: C1 is the sum of A1 and A2 How can I get C1 to remain empty unless there is a number in BOTH cells. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula in spreadsheet
If(A1*A2,A1+A2,"")
Dennis1188 wrote: C1 is the sum of A1 and A2 How can I get C1 to remain empty unless there is a number in BOTH cells. |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula in spreadsheet
Just one note of caution. If you've got a zero for one or both numbers,
that formula would return a blank, not zero. -- David Biddulph "Bob I" wrote in message ... If(A1*A2,A1+A2,"") Dennis1188 wrote: C1 is the sum of A1 and A2 How can I get C1 to remain empty unless there is a number in BOTH cells. |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula in spreadsheet
The final request was "blanks or zero"= nothing
David Biddulph wrote: Just one note of caution. If you've got a zero for one or both numbers, that formula would return a blank, not zero. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to get the spreadsheet address to print on the spreadsheet | Excel Discussion (Misc queries) | |||
| spreadsheet formula | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| Formula Help (new to Spreadsheet) | Excel Worksheet Functions | |||
| How to use same formula throughout the spreadsheet?? | New Users to Excel | |||
Linear Mode
