Keeping cells blank even though formula is input

Spencer101 Spencer101 is offline

Senior Member

Posts: 663

Quote:

Originally Posted by Bootface

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

How about:

=IF(K1237="","",IF(K1237=2,(U1236+1.3),IF(K1237<= 1,U1236+1)))

Does that do what you're after?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Equation Blank cells until input is added	Ross @ Unirope	Excel Discussion (Misc queries)	1	October 19th 09 06:26 PM
Keeping # of Cells constant in a formula	jeannie v	Excel Worksheet Functions	9	February 19th 08 01:20 AM
How do I drag a formula keeping cells the same but changing sheets	Claire	Excel Worksheet Functions	2	October 30th 07 12:16 PM
Keeping the correct cells when making a formula?	Drokare	Excel Worksheet Functions	2	September 14th 07 02:18 AM
How to copy cells with keeping exact formula intact	Stephen	Excel Discussion (Misc queries)	6	April 3rd 05 10:56 PM

All times are GMT +1. The time now is 02:56 PM.

Menu

About Us