| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
simple formula with blank cells
I have values in cells a1 and b1 however a1 or b1 can be blank. The formula
in c1 should add the values of a1 and b1 only if there is a value in a1 and b1 otherwise if a1 or b1 are blank the value of c1 should remain blank. I appreciate help with a formula in c1. |
|
#2
|
|||
|
|||
|
=IF(OR(ISBLANK(A1),ISBLANK(B1)),"",A1+B1)
-Reid "Brian" wrote: I have values in cells a1 and b1 however a1 or b1 can be blank. The formula in c1 should add the values of a1 and b1 only if there is a value in a1 and b1 otherwise if a1 or b1 are blank the value of c1 should remain blank. I appreciate help with a formula in c1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| My formula screws up other reference cells... | Excel Discussion (Misc queries) | |||
| formula update in individual cells in a whole workbook | Excel Discussion (Misc queries) | |||
| Formula help for using a range of cells! | Excel Worksheet Functions | |||
| Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
Linear Mode
