Excel Formula Help (IF, THEN, LESS THAN)

[Harper]

I must be getting rusty on my Excel formulas as I worked this out a few years back.

I have a spreadsheet to help my work out my computer system pricing.
Right now, I have COST + MARGIN = SELL PRICE

Right now, I need help on my MARGIN formula. When I sell a computer system, I want to be able to make 15% of COST PRICE, but no less than$100

15% of COST PRICE is easy
=1+(COST*15%)

However the hard part is IF 1+(COST*15%) = Less Than $100, I do want the value = $100

I am just a little lost on how i put that formula into Excel.
BTW, I do know that LESS THAN is >


At the end of the day, I want some thing that my co-worker can use without him complain then he has to manually have to work things out.

=if((cost*15%)>100,cost*15%,100)

 

[bla!!]

or you could just do this

=max((cost*1.15), 100)

Sorry that should be max not min above (I can't edit for some reason, otherwise I would change it)

*Mod note*

I edited it for you bla!! I think there is a time frame on the edits.

Mak