formula based on prefix
Hi
I need a different markup formula based on prefix in inventory list ie:
ppbolt would get 15% markup (prefix is pp) (Description)
detnut would get 20% markup (prefix is det) (Item Code)
3rnail would get 25% markup (prefix is 3) (Item Code)
col A would be item code
col B would be description (the pp prefix is on some of the items here)
col C would be cost
col D would be retail
Thanks
|