View Single Post
  #1   Report Post  
Old May 1st 05, 10:40 PM
Rochelle B
 
Posts: n/a
Default How do I nest these 3 IF functions?

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