Need formula to default to a certain value if the cell is left blank

[sft429]

What I'm trying to do is make a range of cells default to a value of
3000 if I enter nothing (leave it blank). I would like formulas in
other cells to read it as 3000 but still display as a blank cell.

Thanks

 

[AlfD]

Hi!

If you start with 3000 in each cell and match the text and backgroun
colours, the 3000 will be there but invisible except when you click o
a cell.

If then you put a conditional format on the cell to make it show
different colour of text if the value is not 3000, your entries wil
show and be used.

Not perfect: if an entry of 3000 is made you won't notice it. Does tha
matter?

Al

 

[Ron de Bruin]

Try this if I understand you correct

=IF(A1="",3000,A1)

If you leave A1 empty the formula will display 3000, if A1 have
a other value you see that.

 

[sft429]

Try this if I understand you correct

=IF(A1="",3000,A1)

If you leave A1 empty the formula will display 3000, if A1 have
a other value you see that.

That looks like it may work ok - how about if I want to do it for a
range of cells?

thanks

 

[sft429]

Hi!

If you start with 3000 in each cell and match the text and background
colours, the 3000 will be there but invisible except when you click on
a cell.

If then you put a conditional format on the cell to make it show a
different colour of text if the value is not 3000, your entries will
show and be used.

Not perfect: if an entry of 3000 is made you won't notice it. Does that
matter?

Alf

Thanks for the reply - I'd rather not use color if I didn't have to
because I'll be printing it fairly often.

 

[Frank Kabel]

Hi
just copy this formula down

 

[AlfD]

SFT429:

My suggestion wouldn't impact on printing and require a colour
printer.

Ron:

Putting =IF(A1="",3000,A1) in A1 suggests a circular reference. Is that
what you had in mind?

Alf

 

[JE McGimpsey]

It would only imply a circular reference if the formula were entered in
cell A1.

 

[sft429]

Yep, I just put that in another part of the sheet and it works fine.
Thanks all for your help