B
Bob Zimmerman
The follow work fine in seperate cells.
=IF(AND(R7>0,O7="M"),(R7*I19+50)*0.093,(0))
=IF(AND(R7>0,O7="Q"),(R7*I19+50)*0.27,(0))
=IF(AND(R7>0,O7="S"),(R7*I19+50)*0.53,(0))
=IF(AND(R7>0,O7="A"),(R7*I19+50),(0))
What I want to do is combine the 4 above in 1 cell so the results show in a
single cell.
I can't get it to work.
Any help will be appreciated.
Thanks.
Bob Z
=IF(AND(R7>0,O7="M"),(R7*I19+50)*0.093,(0))
=IF(AND(R7>0,O7="Q"),(R7*I19+50)*0.27,(0))
=IF(AND(R7>0,O7="S"),(R7*I19+50)*0.53,(0))
=IF(AND(R7>0,O7="A"),(R7*I19+50),(0))
What I want to do is combine the 4 above in 1 cell so the results show in a
single cell.
I can't get it to work.
Any help will be appreciated.
Thanks.
Bob Z