default values in a cell

  • Thread starter Thread starter KRK
  • Start date Start date
K

KRK

Hello, can you help me please

Cell B1 contains a complex mathematical formula which requires (in several
places) a number from cell A1.

Cell A1 can contain any integer number, but it is usually the same (30).

I would like to be able to leave cell A1 empty, and only enter a number when
it is not 30 ,

ie the default value of A1 is 30, unless specified.

How do I go about this ?

Should I look at conditional formatting, or put lots of IF functions into an
already complex formula?

Thank as always

KK
 
Use 2 cells

Modify the complex formula to use B1 rather than A1 ( or any other un-used
cell)

In B1 enter:

=IF(A1="",30,A1)
 
Back
Top