Solved How to keep number from showing formulated cells

October 9, 2014 at 14:21:02
Specs: Windows 8
I have an Excel spreadsheet that has formulas copied into them. Because of the nature of the formulas, a value is there all of the time even though none of the cells that make up the formula have any values in them. Would like to have nothing in the cell until information is put in the cells that the cell is getting information from.

Thanks,


See More: How to keep number from showing formulated cells

Report •


#1
October 9, 2014 at 15:49:14
Not at all sure if I understand what your looking for.

But from the sounds of it, you want a cell,
which contains a formula,
to not display anything,
till a value is entered in a second cell.

So something like this:

=IF(A1 = "" , "" , A1 + 1 )

If you enter this in cell B1,
then cell B1 will not do a calculation
or display anything
until a number is entered in A1

I think that is what your looking for.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
October 9, 2014 at 18:18:08
I'm going to pick a nit here...

If you enter this in cell B1, then cell B1 will not do a calculation or display anything
until a number is entered in A1

Well, yes, it will "calculate" (actually "evaluate") the formula and the result will be an empty cell. All formulas in the sheet "calculate" when the sheet calculates, which happens every time a cell is changed, assuming calculation is set to automatic.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
October 9, 2014 at 18:46:11
✔ Best Answer
A nit very well picked....

Sometimes in simplifying an explanation, exactitude is lost.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question