Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manual Input/Calculation in Same Cell
Hello,
I've programmed my worksheet to automatically calculate a number but sometimes we have to enter a manual number. Is it possible to input a manual number yet still be able to keep the programmed calculation for the same cell? Jean9 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manual Input/Calculation in Same Cell
Use two cells:
Say in Z100 we usually have =A1/B1, but sometimes we want a manual value instead. In Z100 enter: =IF(B9="",A1/B1,B9) so if B9 is empty, the formula is used. If B9 has a value, the value is used. -- Gary''s Student - gsnu200753 "Jean9" wrote: Hello, I've programmed my worksheet to automatically calculate a number but sometimes we have to enter a manual number. Is it possible to input a manual number yet still be able to keep the programmed calculation for the same cell? Jean9 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manual Input/Calculation in Same Cell
Hi Gary,
I've tried your suggestion and when entering the manual number it works but when no manual number, the calculation does not work at all. What I'm I doing wrong? Jean9 "Gary''s Student" wrote: Use two cells: Say in Z100 we usually have =A1/B1, but sometimes we want a manual value instead. In Z100 enter: =IF(B9="",A1/B1,B9) so if B9 is empty, the formula is used. If B9 has a value, the value is used. -- Gary''s Student - gsnu200753 "Jean9" wrote: Hello, I've programmed my worksheet to automatically calculate a number but sometimes we have to enter a manual number. Is it possible to input a manual number yet still be able to keep the programmed calculation for the same cell? Jean9 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manual Input/Calculation in Same Cell
One possibility: You're "clearing" the manual number by using the space
bar. That leaves a space character in the cell and the comparison with the null string fails. If that's the case, you can use =IF(ISNUMBER(B9),B9,A1/B1) In article , Jean9 wrote: I've tried your suggestion and when entering the manual number it works but when no manual number, the calculation does not work at all. What I'm I doing wrong? Jean9 "Gary''s Student" wrote: Use two cells: Say in Z100 we usually have =A1/B1, but sometimes we want a manual value instead. In Z100 enter: =IF(B9="",A1/B1,B9) so if B9 is empty, the formula is used. If B9 has a value, the value is used. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Reference VS. Manual Input? | Excel Worksheet Functions | |||
Calculation - Automatic and Manual | Excel Discussion (Misc queries) | |||
Automatic/Manual Calculation | New Users to Excel | |||
Calculation set as Manual | Excel Discussion (Misc queries) | |||
Manual / Automatic Calculation | Excel Discussion (Misc queries) |