That was pretty rude Don...

Sorry that I haven't got the 'nesting' thing down - to figure it out for
myself. I thought that's why this online help is here. The first time I asked
about nesting, I wasn't explaining myself thoroughly and clearly. I wasn't
even sure of what I needed. Poor Arvi, I must of really sent himm for a loop.

Then the other questions were in regards to 1 cell, doing 1 IF function,
based on the criteria. Now I need this 1 cell to do 1 of three calculations,
based on 1 of 3 different criterias and without returning a #value!

To be honest, this is my first attempt at nesting. I believe I am having a
parenthesis problem.

"Don Guillett" wrote:

Go back to your other question and use the answers to figure it out

--
Don Guillett
SalesAid Software

"Rochelle B" wrote in message
...
I need to nest these 3 if functions into 1 cell.
=(J15="X")*(IF(M15<$AB$10,M15*S10,M15*O10)
=(K15="X")*(IF(M15<$AB$11,M15*S11,M15*O11)
=(L15="X")*(IF(M15<$AB$12,M15*S12,M15*O12)

Without excel wanting to multiply all three?

All of you have provided great help today? Can this one be tackled
too?????