I'm am working on an Excell based quote sheet and have run into an issue that I'm not sure how to handle.
I want a cell to equal it'self * a number.

Example: I want a number to be typed into a cell, lets say 3.
Once that cell is exited I want it to change to the equivilant of 3 * 15.
So instead of the outcome being 3 it is now 45.
That way I am not using multiple collums or rows for a single equation.

I tried the formula within cell c26 as followes:
c26*15, but Excell doesn't like that at all and I get a blue dot saying "unprotected formula".

An ideal result is similar to when you specify a change of decimal place.
It automaticly changes from the number you entered into that number devided or multiplied by 10, 100, etc...
If I can control that kind of functionality that would be awsome.

Please advise if something like this is even possible.
Any help would be greatly appreciated.
Thanks in advance.
EFGMan