Combining to IF AND statements

[ddub25]

=IF(AND(O58="EUR", P58="GBP"),Q58*Q41,0)

=IF(AND(O58="USD", P58="GBP"),Q58*Q38,0)

I would like to combine these two formulas. Whenever I try I seem to get the syntax wrong. Can anyone help? Thanks.

Dan

 

[schielrn]

Maybe try:

=IF(AND(O58="EUR", P58="GBP"),Q58*Q41,IF(AND(O58="USD", P58="GBP"),Q58*Q38,0))

or:

=IF(P58="GBP",if(O58="EUR",Q58*Q41,IF(O58="USD",Q58*Q38,0)),0)

Hope that helps.

 

[VoG]

Try

=IF(AND(O58="EUR", P58="GBP"),Q58*Q41,IF(AND(O58="USD", P58="GBP"),Q58*Q38,0))

 

[ddub25]

cheers for you help, much appreciated.

Dan