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,

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 A1I think that is what your looking for.

MIKE

message edited by mmcconaghy

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 A1Well, 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.

A nit very well picked.... Sometimes in simplifying an explanation, exactitude is lost.

MIKE

Ask Your Question

Weekly Poll