Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Bascialy, i want to show the retail value of a kilo of cheese to the customer at 100g price
Formula: to divide 10 from a kilo to 100g & then add 75%
iMac, Mac OS X (10.7.2)
This may work for you:
C3=B3/10
D3=C3*(1+$D$1/100)
select C3 and D3, then fill down as needed
Thanks chap
Mark,
Do you have other questions related to this topic?
No, alls well.
Regards
Formula: to divide 10 from a kilo to 100g then add 75%
