Thread
:
Calculations
View Single Post
#
3
Posted to microsoft.public.excel.misc
Pete_UK
Posts: n/a
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
Reply With Quote