default values in a cell

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
 
G

Gary''s Student

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

References omit formatting and return cell address - not data 1
help with a formula please 3
Value in one cell visible of another cell has anything in it 4
Display entire number in cell 3
Counting unique values in a row 8
Lookup function to cell containing multiple values 3
Macro to extract few values from a cell 3
Conditional Formatting macro: simple, but doesn't work 6

Top