LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default multiplying everything in line A X 50 = results in Line B

Assuming data in A2 down,
Put in B2: =A2*50
Copy B2 down as far as required by dragging the fill handle (the solid
square at the bottom right corner of the cell).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"benjamin" wrote:
I have hours in Line A, and Need the code to multiply by 50/hr and have the
results in Line B

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a limit line CurtainMary Charts and Charting in Excel 2 November 22nd 06 09:55 PM
Combination chart - Line - Column on 2 Axes Debbie Charts and Charting in Excel 2 November 16th 06 09:04 PM
Chart Type - Line Column adding a 2nd line [email protected] Charts and Charting in Excel 1 October 24th 06 04:17 PM
Vertical line isn't vertical! [email protected] Charts and Charting in Excel 2 September 13th 06 01:54 PM
Squiggly line to show more dramatic results? kelp New Users to Excel 2 March 16th 06 09:39 PM


All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"