Making a negative number populate 100

[Alaskan_grunt]

Ok so I am trying to do a sales tracker. With that said if the total gross profit for a sales professional on one sale is $-2,000 his minimum commission is $100 but at the same time if his gross profit is $3,000 he would earn 25% of the $3,000. My question is how do I get the cell to populate a $100 minimum no matter if the gross profit is $200 or $-2,000 but yet at the same time still being able to populate the commission of $750 for a $3,000 gross profit at the 25% commission rate?

[vlady]

maybe

=MAX(100,A1*0.25)

[Alaskan_grunt]

That worked great. Thank you so much.

[vlady]

your welcome, You can mark your thread solved.

How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.

[Alaskan_grunt]

maybe

=MAX(100,A1*0.25)

I have one more question. This worked for what I wanted it to but I need the cell to stay blank until there is something to calculate for example,

Here is my layout:
Cell E7 is for how many units were sold
Cell H7 is How much gross profit is
Cell J7 is where the total commission earned is calculated.
Now until I add a value to H7, J7 should be blank. Here is the formula I am now using based on a modification of your formula.
=MAX(100,E7*H7*0.25)

The problem I am running into is that it automatically populates 100 even with no number in H7.

[vlady]

ok, check firs H7 if blank then J7 blank

J7=IF(H7="","",MAX(100,E7*H7*0.25))

[Alaskan_grunt]

Works perfect. Thank you much. I will now mark it as solved.