Multiplication in one cell

[Guest]

Is there a formula where I can input a number in a cell and get the sum of
that number X $4.20 .
Example
Cell a1
If i typed in 5 I would get $21.00
I tried #*$4.20= but it doesnt work
any ideas

 

[Guest]

Is there a formula where I can input a number in a cell and get the sum of
that number X $4.20 .
Example
Cell a1
If i typed in 5 I would get $21.00
I tried #*$4.20= but it doesnt work
any ideas

You're asking for a circular reference. A cell that changes itself. I don't
believe it can be done simply. You'd have to use VBA trapping to sense somebody
typing in that one cell and then modify it I guess. It's probably more trouble
and effort learning programming on your part than it's worth.

Any reason you can't just put:

[B1] = A1*4.20

Bill