The below is a question that I asked on the Excel Discussion Group Board:
<-------------->
How can I add, subtracts, etc. (all functions) with a cell that has a
number-range.  How do I input a number range in currency mode in the first
place?  To provide you the example at hand...

I am doing cost-analysis for a proposal.  My Excel Sheet is set-up with
column A showing the products, service, or other expenses.  Column B shows
the cost of each expense.  Column C shows how many of the given product,
services, or otherwise are needed.  Column D multiplies the Column B cells
with the Column C cells.  In the last row of Column D, all of the dollar
amounts in Column D are added (e.g. "SUM=D6:D30").

Some of the costs are not solid costs and instead have a range, such as
$65,000 - $100,000.

First, how can I place "$65,000 - $100,000" in Currency Mode?  After doing
such, how do insert in another cell that multiplies that amount by another
number (the number of products, services, etc. needed)?

In the end, I want the spreadsheet to show this:
A25: "Computer Vocational Education Instructor/Local Account and Filtering
Software Manager"
B25:  "$65,000 - $100,000"
C25: "2"
D25: "=B25*C25" --> "$130,000 - $200,000"

Then, I want that ("$130,000 - $200,000") to be included in the Grand Total
sum and create a range.  For example, if without that range the Grand Total
amount is $62,162.32, I would want it to be changed to read "$192,162.32 -
$262,162.32".

Can ths be done with Excel?

-Zakhary

<------------------>

I was informed by a Silver Level Contributor that this can not happen in
Excel.  Analyzed, the suiggestion I have is to make this capable of happening
in the next edition of Excel.  It can be very beneficial for various purposes.

-Zakhary