Mark up Formula

[mbrooks1009]

I am looking for a formula to mark up total cost. Example, cell E4 is total cost, if E4 is under $100 mark up 4%, if E4 is over $100 mark up 2%.

Appreciate the help.

 

[etaf]

if you want to change the value in E4 - then you need VBA
or
you if you are summing other sales
you could say

= if ( sum(other cells) <=100, Sum(other cells) *0.04 , Sum(other cells) *0.02)

 

[mbrooks1009]

Thank you for the response. I do not want to change in the value of E4, want the new value to appear in E5. This way I can still see cost before mark up.

 

[Joe4]

Thank you for the response. I do not want to change in the value of E4, want the new value to appear in E5. This way I can still see cost before mark up.

Then you should just be able to use the structure etaf gave you to write this:

=IF(E4<100,E4*1.04,E4*1.02)

to get the final price/cost.

If you just want to see the value of the mark-up (and not the final price/cost), just use:

=IF(E4<100,E4*0.04,E4*0.02)

Note that you did not mention what should happen if E4 is exactly 100.
Based on your answer to that, the "<" may need to change to "<=".

 

[etaf]

ok
in E5
=IF(E4="","", if ( E4 <=100, E4 *0.04 , E4*0.02))

assuming if the e4 is blank you want a blank in the cell or do you want zero
or to increase by the %
=IF(E4="","", if ( E4 <=100, E4 *1.04 , E4*1.02))

 

[mbrooks1009]

Then you should just be able to use the structure etaf gave you to write this:

=IF(E4<100,E4*1.04,E4*1.02)

to get the final price/cost.

If you just want to see the value of the mark-up (and not the final price/cost), just use:

=IF(E4<100,E4*0.04,E4*0.02)

Note that you did not mention what should happen if E4 is exactly 100.
Based on your answer to that, the "<" may need to change to "<=".

Thank you, it works great, Still a novice, but learning.

 

[Joe4]

You are welcome.
Glad we were able to help!

Here is some good documentation on the IF function: IF function - Microsoft Support
Microsoft has this kind of documentation on all their functions, which can be found with a simple Google Search.

 

[mbrooks1009]

You are welcome.
Glad we were able to help!

Here is some good documentation on the IF function: IF function - Microsoft Support
Microsoft has this kind of documentation on all their functions, which can be found with a simple Google Search.

Thank you, this is very useful.