calculating a certain cell to add at different prices

Giganews Newsgroups
Subject: calculating a certain cell to add at different prices
Posted by:  Melissa (mgdra…@charter.net)
Date: Mon, 6 Oct 2003

I need to write a formula that sees a number in a certain
cell and then calculates the total based on the number.
For instance,  the total number is 350 and I want a
formula that calculates the first 250 at $2.95 each and
the next 100 at $2.75 each.  Is that possible?

Replies