Function Error IF Statement
 

The follow work fine in seperate cells.

=IF(AND(R70,O7="M"),(R7*I19+50)*0.093,(0))
=IF(AND(R70,O7="Q"),(R7*I19+50)*0.27,(0))
=IF(AND(R70,O7="S"),(R7*I19+50)*0.53,(0))
=IF(AND(R70,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

Function Error IF Statement
 

Not sure which order the functions should be, but this combination should
help you;

=IF(AND(R70,O7="M"),(R7*I19+50)*0.093,
IF(AND(R70,O7="Q"),(R7*I19+50)*0.27,
IF(AND(R70,O7="S"),(R7*I19+50)*0.53,
IF(AND(R70,O7="A"),(R7*I19+50),0))))



--
Regards
Dave Hawley
www.ozgrid.com
"Bob Zimmerman" wrote in message
...
The follow work fine in seperate cells.

=IF(AND(R70,O7="M"),(R7*I19+50)*0.093,(0))
=IF(AND(R70,O7="Q"),(R7*I19+50)*0.27,(0))
=IF(AND(R70,O7="S"),(R7*I19+50)*0.53,(0))
=IF(AND(R70,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

Function Error IF Statement
 

Another way..using LOOKUP()

=IF(AND(COUNT(SEARCH({"A","M","Q","S"},O7)),R70),
(R7*I19+50)*LOOKUP(O7,{"A","M","Q","S"},{1,0.093,0 .27,0.53}),0)

--
Jacob (MVP - Excel)


"Bob Zimmerman" wrote:

The follow work fine in seperate cells.

=IF(AND(R70,O7="M"),(R7*I19+50)*0.093,(0))
=IF(AND(R70,O7="Q"),(R7*I19+50)*0.27,(0))
=IF(AND(R70,O7="S"),(R7*I19+50)*0.53,(0))
=IF(AND(R70,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

Function Error IF Statement
 

Thank you it works like a charm.

"ozgrid.com" wrote:

Not sure which order the functions should be, but this combination should
help you;

=IF(AND(R70,O7="M"),(R7*I19+50)*0.093,
IF(AND(R70,O7="Q"),(R7*I19+50)*0.27,
IF(AND(R70,O7="S"),(R7*I19+50)*0.53,
IF(AND(R70,O7="A"),(R7*I19+50),0))))



--
Regards
Dave Hawley
www.ozgrid.com
"Bob Zimmerman" wrote in message
...
The follow work fine in seperate cells.

=IF(AND(R70,O7="M"),(R7*I19+50)*0.093,(0))
=IF(AND(R70,O7="Q"),(R7*I19+50)*0.27,(0))
=IF(AND(R70,O7="S"),(R7*I19+50)*0.53,(0))
=IF(AND(R70,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



.