Monday, February 8, 2016

yogi_Compute Mark Up On Wholesale Per Specified Criteria

Google Spreadsheet   Post  #2032
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-08-2016
post by: John Pitt :
https://productforums.google.com/forum/#!topic/docs/j_pOmrEg9-s;context-place=forum/docs

Setting up a price matrix for small business.


I have a set of wholesale cost ranges that I would like to reference. For example if the product cost is $1 to $15 the mark up is 300%  if the product cost is $15 to $45 the mark up is 250%  and so on.

I have a google docs sheet with my items name and description listed in column a and product cost in column b and would like to have the mark up automatically populate in column c.  Is this possible?

Any help will be appreciated.



---------------------------------------------------------------------------------------