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)
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)