thanks for the info. i have done as you told me, please clarify what profit margin and markup mean.

in my excel for one of the items, i have:

profit is 2.95 (i know this)
profit margin is 84.48214286
markup is 544.4188723
what do profit margin and markup mean? does markup mean that i am marking up the product 544% from cost?