LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default adding decreasing numbers

Hi. Im trying to set something up where I put a number(y) in a cell that
represents the quantity of x. (x is the product Im buying and y is the
amount). The thing is that after I buy one for say 400, the next time I buy
It will cost 330, and the number decreases by 70 every time i buy. Is there
an easy way to total up the cost of (y) amount of (x). Example:
need to buy 3 boxes: 1st box costs 400;2nd box costs 330;3rd box costs 260
total: 990
How do I automatically calculate the total by putting in the amount of
boxes needed in a cell in this situation.

 
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 numbers to an incomplete numerical list hana Excel Discussion (Misc queries) 17 January 11th 07 09:46 PM
Adding to a column of numbers Colleen Excel Worksheet Functions 1 January 4th 06 06:26 AM
Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA Master Excel Worksheet Functions 2 July 12th 05 05:03 PM
Excel Adding duplicated numbers together JJ Joobler Excel Discussion (Misc queries) 1 January 7th 05 01:24 AM
Re What is the formula for adding multiple numbers in a cell merlin_au Excel Discussion (Misc queries) 2 January 4th 05 11:50 AM


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

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

About Us

"It's about Microsoft Excel"