Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default different phrasing

I want to know how to enter the data 15 bikes per week for 52 weeks at
$250.00 on Excel
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default different phrasing

If you are looking for a more general approach, then use column A for
Number of bikes, column B for Duration, column C for Unit rate (per
bike per week) and column D for the Total. Put appropriate headings in
A1 to D1, then in A2 you can enter 15, in B2 you can enter 52, in C2
you can enter 250 (and format the cell as currency), then in D2 you
can enter this formula:

=A2 * B2 * C2

to get your answer.

If you just want to use Excel as a calculator, then in A1 you can
enter:

=15 * 52 * 250

Hope this helps.

Pete

On Jul 14, 10:21*pm, Foxy Old Lady at 60 <Foxy Old Lady at
wrote:
I want to know how to enter the data 15 bikes per week for 52 weeks at
$250.00 on *Excel


Reply
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
Phrasing RYRYSMYGUY Excel Discussion (Misc queries) 2 September 6th 06 01:32 PM


All times are GMT +1. The time now is 05:47 PM.

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"