| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Keeping cells blank even though formula is input
I have the following formula in my work sheet in cell U1237
=IF(K1237=2,(U1236+1.3),IF(K1237<=1,U1236+1)) however when I drag this formula down it calculates blank cells as a 0 and returns a figure. How do I keep the below cells blank whilst keeping the formula. When I try the Isblank method I just get an error saying too many arguments. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Equation Blank cells until input is added | Excel Discussion (Misc queries) | |||
| Keeping # of Cells constant in a formula | Excel Worksheet Functions | |||
| How do I drag a formula keeping cells the same but changing sheets | Excel Worksheet Functions | |||
| Keeping the correct cells when making a formula? | Excel Worksheet Functions | |||
| How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) | |||
Threaded Mode
