| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leaving a total sum cell blank until other cells are filled
Hi there, some help needed please for probably a simple problem.
Lets say I have a value in cell A1. A2 is blank for now and the total of the SUM will be in A3. How can i get it so that A3 is blank until A2 is filled in. Any would be appreciated |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Leaving a total sum cell blank until other cells are filled
Try this in A3:
=IF(OR(A1="",A2=""),"",A1+A2) That checks for both A1 and A2 being empty, and if either of them are then the formula will return a blank. If you only want to test for A2, then you can do this: =IF(A2="","",A1+A2) No need for SUM. Hope this helps. Pete On Dec 8, 12:53*pm, Ric Crombie wrote: Hi there, some help needed please for probably a simple problem. Lets say I have a value in cell A1. A2 is blank for now and the total of the SUM will be in A3. How can i get it so that A3 is blank until A2 is filled in. Any would be appreciated |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Leaving a total sum cell blank until other cells are filled
On 8 Dec, 13:01, Pete_UK wrote:
Try this in A3: =IF(OR(A1="",A2=""),"",A1+A2) That checks for both A1 and A2 being empty, and if either of them are then the formula will return a blank. If you only want to test for A2, then you can do this: =IF(A2="","",A1+A2) No need for SUM. Hope this helps. Pete On Dec 8, 12:53*pm, Ric Crombie wrote: Hi there, some help needed please for probably a simple problem. Lets say I have a value in cell A1. A2 is blank for now and the total of the SUM will be in A3. How can i get it so that A3 is blank until A2 is filled in. Any would be appreciated Pete, that was blooming marvellous. Thanks for the quick easy response. Ric |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Leaving a total sum cell blank until other cells are filled
You're welcome, Ric - thanks for feeding back.
Pete On Dec 8, 1:08*pm, Ric Crombie wrote: Pete, that was blooming marvellous. Thanks for the quick easy response. Ric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding cells but leaving blank if not populated | Excel Worksheet Functions | |||
| Leaving Cell Blank | Excel Worksheet Functions | |||
| Leaving Cell Blank. | Excel Worksheet Functions | |||
| Colouring Ranges & Leaving Cells Blank | Excel Discussion (Misc queries) | |||
| Leaving a cell blank. Not NA(), not "". | Excel Worksheet Functions | |||
Linear Mode
