combine multiple IF/AND/OR statements

[katja328]

Trying to solve the following formula:

If my input page B13 is either New Lease In-House or New Lease w/Co-Borker andmy input page B43 is - then take cell D57 in my Analysis report, mulitply it by cell B32 from Input page and divide it by 2, otherwise, take cell D57 on the analysis report, mulitply it by B42 on Input page and divide it by 4.

I think I have a mess up with my brackets....

This is what I have:

=IF((OR('Input Page'!B13="New Lease In-House",'Input Page'!B13="New Lease w/Co-Broker"))AND('Input Page'!B43="-",'Analysis Report'!D57*'Input Page'!B32/2,'Analysis Report'!D57*'Input Page'!B32/"4")

[DonkeyOte]

Works along lines of:

=IF(AND(test1,OR(test2,test3)),do this,do that)

[katja328]

Works along lines of:

=IF(AND(test1,OR(test2,test3)),do this,do that)

changed it to read:
=IF(AND('Input Page'!B43="-"),OR('Input Page'!B13="New Lease In-House",'Input Page'!B13="New Lease w/Co-Broker")),'Analysis Report'!D57*'Input Page'!B32/”2”,'Analysis Report'!D57*'Input Page'!B32/"4")

is still not working....

[DonkeyOte]

You have a misplaced closing parenthesis... no need for ) prior to the OR.

[katja328]

THank you!!!!