Answer for:

Calculation within a cell.

Message 12 of 11

View entire thread
0 Votes

There is a "manual" way to do this... instead of entering "100" into your cell and using some other cell to multiply by 1.2, put =100*1.2 into your cell. That way you don't need a (hidden) separate cell. You do now need to be careful to only change the "100" and not the other part of the formula...

I use this quite a lot to be able to calculate "plus-tax" and "plus-margin" values without needing additional cells or doing calculations on paper :-)