Guru's:

This is a tricky one!

Is it possible to have a calculation formula in a cell or set/range of cells
if one condition exists and allow for data entry if needed and still have the
calculation take place against the entered data under other conditions?

Say, cell F5 - Q5 are calculated formulas based on a value entered in cell
E5, but under other conditions, I'd like to either add or enter values into
cell, If there is no value in E5 (Show all cells blank), then allow for
manual data entry as needed and do calculations against cell F5 - Q5 those
entered values? In code, I guess, that would be an If ThenElse statement, is
it possible in excel?

Thanks in advance...

Hi Jay,

It is not possible through formulas because as soon as you manually
enter something over the blank cells the formula got erased. And vice
versa.

Thanks,

Shail


Jay wrote:
Guru's:

This is a tricky one!

Is it possible to have a calculation formula in a cell or set/range of cells
if one condition exists and allow for data entry if needed and still have the
calculation take place against the entered data under other conditions?

Say, cell F5 - Q5 are calculated formulas based on a value entered in cell
E5, but under other conditions, I'd like to either add or enter values into
cell, If there is no value in E5 (Show all cells blank), then allow for
manual data entry as needed and do calculations against cell F5 - Q5 those
entered values? In code, I guess, that would be an If ThenElse statement, is
it possible in excel?

Thanks in advance...

Thanks, I kind of figured that! Can it be done in code?

Thanks

"shail" wrote:

Hi Jay,

It is not possible through formulas because as soon as you manually
enter something over the blank cells the formula got erased. And vice
versa.

Thanks,

Shail


Jay wrote:
Guru's:

This is a tricky one!

Is it possible to have a calculation formula in a cell or set/range of cells
if one condition exists and allow for data entry if needed and still have the
calculation take place against the entered data under other conditions?

Say, cell F5 - Q5 are calculated formulas based on a value entered in cell
E5, but under other conditions, I'd like to either add or enter values into
cell, If there is no value in E5 (Show all cells blank), then allow for
manual data entry as needed and do calculations against cell F5 - Q5 those
entered values? In code, I guess, that would be an If ThenElse statement, is
it possible in excel?

Thanks in advance...

Hi Jay,

Sorry for delay in reply.

Here is something for you. This is just an example, let me see if this
works for you too.
Make a dropdown validation list at the cell D8 as
=IF(A1="","",B8)


And at the B8 cell you need to have the formula with the output. Say
=B1+B2

When the cell A1 is empty, the cell D8 too will show nothing but an
empty cell where you can make enter your Data.

And when the cell A1 has something in it, the output of the formula
will be displayed there.

Hope this is somewhat near to what you need. And do let me know if this
gave you idea how you can toggle between the cell for entry and the
output of the formula.


Thanks,

Shail



Jay wrote:
Thanks, I kind of figured that! Can it be done in code?

Thanks

"shail" wrote:

Hi Jay,

It is not possible through formulas because as soon as you manually
enter something over the blank cells the formula got erased. And vice
versa.

Thanks,

Shail


Jay wrote:
Guru's:

This is a tricky one!

Is it possible to have a calculation formula in a cell or set/range of cells
if one condition exists and allow for data entry if needed and still have the
calculation take place against the entered data under other conditions?

Say, cell F5 - Q5 are calculated formulas based on a value entered in cell
E5, but under other conditions, I'd like to either add or enter values into
cell, If there is no value in E5 (Show all cells blank), then allow for
manual data entry as needed and do calculations against cell F5 - Q5 those
entered values? In code, I guess, that would be an If ThenElse statement, is
it possible in excel?

Thanks in advance...