Right, I know that. But I also wrote "but I'm trying to get the final
result by only using one cell" In other words, I want the calculation
to be figured out by only having to take up one cell, I don't want to
have to use multiple cells to figure the problems out. But either way
it looks like that's what I'm going to have to do.

Thanks anyway.

Bernie Deitrick wrote:
You answered your own question:

I know I can achieve it by putting different
formulas in a couple of seperate cell's

HTH,
Bernie
MS Excel MVP