software

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.

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?

--
Kind regards,

Niek Otten

quot;KWquot; gt; wrote in message ...
gt; I'm working on a spreadsheet, and I want a cell to automatically calculate
gt; the number I put in by a predetermined number. So, I put 2 in the cell, I
gt; want it to multiply by 27 and put the total in the cell.
If you intend to type the number into cell A1, then in B1 enter this
formula:

=IF(A1=quot;quot;,quot;quot;,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