different phrasing

  • Thread starter Foxy Old Lady at 60
  • Start date
F

Foxy Old Lady at 60

I want to know how to enter the data 15 bikes per week for 52 weeks at
$250.00 on Excel
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top