Thread: Calculations
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default Calculations

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