View Single Post
  #2   Report Post  
Old May 1st 05, 10:58 PM
Don Guillett
 
Posts: n/a
Default

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?????