Thread: message box in an excel cell
View Single Post
  #17 (permalink)  
Old 02-24-2008, 07:06 AM
Troy2287 Troy2287 is offline
Banned
  
Join Date: Feb 2008
Location: New South Wales, Australia
Posts: 23
iTrader: (0)
Troy2287 is on a distinguished road
Send a message via MSN to Troy2287
Default
In the 3rd column, in the first cell put =PRODUCT(B1,1.2). This will give you your first value. Highlight the entire column, and click "Fill down". (I think it's in the edit menu on older versions then 2007).
Reply With Quote