ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   different phrasing (https://www.excelbanter.com/excel-worksheet-functions/194829-different-phrasing.html)

Foxy Old Lady at 60

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

Pete_UK

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




All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com