Calculations

K

KW

I'm working on a spreadsheet, and I want a cell to automatically calculate
the number I put in by a predetermined number. So, I put 2 in the cell, I
want it to multiply by 27 and put the total in the cell.
 
N

Niek Otten

Don't. Use another cell with a formula. I can't think of any good reason to do this what Excel wasn't designed to do.
Of course it can be done using VBA, but why should you?
 
P

Pete_UK

If you intend to type the number into cell A1, then in B1 enter this
formula:

=IF(A1="","",A1*27)

This will show a blank if A1 is empty, otherwise it will give 27 times
whatever is typed into A1.

Hope this helps.

Pete
 
Top