Excel 2007 : Manipulating a range of numbers in one cell

[mike.v]

I'm thinking there isn't a simple way to do this, but I'd like to know for sure for my future reference.

The scenario is this: the sheet is a budget, and the hours worked consist of a range, say, 5 - 7. Is there a way to take this range, keep it in one cell, multiply it by some sort of hourly rate, and produce a total range? Ideally, I'd want this:

Hours Rate Total
5-7 $100 $500-$700

And then I'd like to be able to continue to manipulate the numbers in the total column in further formulas.

I know this isn't really reasonable, and there are better ways to do it, but I'd really like to know if I can confine these ranges to single cells and still work with them.

[tigeravatar]

mike.v,

See attached. Is that what you're looking for? Let me know if you have any questions.

~tigeravatar

[mike.v]

Wow, that was a lot faster than I would have thought. Thank you, it's just what I needed. My only other question is whether the numbers in the total column can be formatted like currency - with commas - or not.