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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping cells blank even though formula is input
On 24/07/2012 6:54 PM, Bootface wrote:
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 Hi =IF(K1237="","",IF(K1237=2,(U1236+1.3),IF(K1237<= 1,U1236+1))) HTH Mick. |
#3
|
|||
|
|||
Quote:
=IF(K1237="","",IF(K1237=2,(U1236+1.3),IF(K1237<= 1,U1236+1))) Does that do what you're after? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping cells blank even though formula is input
"Bootface" wrote:
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. I presume K1237 is never between 1 and 2, e.g. 1.5. Otherwise, your formula would be flawed to start with. So you might write: =IF(K1237="","",IF(K1237=2,U1236+1.3,U1236+1)) No need to test K1237<=1. That is implied when K1237=2 is false. |
#5
|
|||
|
|||
Quote:
Hi Mick Thanks very much that has done the trick :-) |
#6
|
|||
|
|||
Thanks Spencer yes it does :-)
|
Reply |
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) |