Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
default values in a cell
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
default values in a cell
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) -- Gary''s Student - gsnu200908 "KRK" wrote: 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default values | Charts and Charting in Excel | |||
Default values for cell formatting and Pivot tables | Excel Discussion (Misc queries) | |||
SET DEFAULT VALUES IN CELL TO RECORD NEGATIVE | Excel Discussion (Misc queries) | |||
Default Values | Excel Discussion (Misc queries) | |||
Default Cell Values & Save Changes Dialog Box | Excel Discussion (Misc queries) |