- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- calculating a certain cell to add at different prices

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?

- Re: calculating a certain cell to add at different prices posted by Paul on Mon, 6 Oct 2003
- Re: calculating a certain cell to add at different prices posted by Ron de Bruin on Mon, 6 Oct 2003