Help, help, help!

[DMESS18]

Any help would be greatly appreciated. I have figured out everything, but there is a slight curveball now.

Here is the situation:
If the DEAL GROSS is a positive number and FINANCE is a positive, then the max finance Commission that can be awarded 5% of Finance, not to exceed 100.
However, if DEAL GROSS is less than 0, then the max Finance Comm that can be awarded is 5%, not to exceed 25.

The current formula for Finance Comm is: =MIN(100,(O1*0.05)) I somehow need to add =MIN(25,(if M2 is <0)

I cannot figure out how to get the formula to do both! HELP PLEEEEASE!

M N O P
[TABLE="width: 310"]
<colgroup><col span="3"><col></colgroup><tbody>[TR]
[TD]Deal Gross[/TD]
[TD]Comm[/TD]
[TD]Finance[/TD]
[TD]Comm[/TD]
[/TR]
[TR]
[TD]2500.00[/TD]
[TD]625.00[/TD]
[TD]8000.00[/TD]
[TD="align: right"]100.00[/TD]
[/TR]
[TR]
[TD]-1250.00[/TD]
[TD]100.00[/TD]
[TD]1200.00[/TD]
[TD="align: right"]60.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[etaf]

=if ( and(m1>0, n1>0), min(100,(o1*0.05)), min(25,(o1*0.05)))

 

[snjpverma]

What outcome do you want if the deal gross is 0 ?

 

[snjpverma]

Alternatively,

=if(m1*n1>0),min(100,(o1*.05)),min(25,(o1*.05)))

 

[DMESS18]

ETAF YOU ARE PURE GENIUS!!! Thank you so much...it worked perfectly!!!!

 

[etaf]

you are welcome