Calculate profit meeting a minimum number

[KAFish]

Hi,

I am trying to figure out a formula to calculate a margin that has to meet a minimum number.

example- I have a cost of $100 and I want to make a minimum of $50 or 40%, which ever is higher.

Any ideas?

Thanks
Kirk

 

[Marcílio_Lobão]

KAFish, Good evening.

Try to use:

Suppose: A1 = Cost

=MAX(50, A1*40%)

Is that what you want?
I hope it helps.

 

[KAFish]

KAFish, Good evening.

Try to use:

Suppose: A1 = Cost

=MAX(50, A1*40%)

Is that what you want?
I hope it helps.

Thank you very much Marciio, exactly what I was after.

Kirk

 

[Marcílio_Lobão]

Thanks for the feedback!

Glad to help you.