|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?