Applying A Price Increase

Question

Hi team.&nbsp; I need to apply a 5% increase to all dollar values in a spreadsheet that is FULL of imbedded formulas.&nbsp; Is there a simple way of doing that?&nbsp; Other than manually?If anyone could help, I would really appreciate it.CheersJulie

damien_rosario · Answer

Hi&nbsp;paul_julz&nbsp;&nbsp;Maybe provide a screen shot or sample file of what you are working with if possible.&nbsp; Hard to know what to answer without seeing what you are working with.&nbsp;We can assess it once we see the example?&nbsp;CheersDamien

paul_julz · Answer

Hi there&nbsp;Thanks for answering.&nbsp; I have attached the spreadsheet which I was trying to do all of that manually, but there is no much imbedded in it that I just can't work out how to do it.&nbsp;Cheers&nbsp;Julie

damien_rosario · Answer

Hi&nbsp;paul_julz&nbsp;&nbsp;Thanks for the sample.&nbsp;There's a lot here and I'm not sure which sheet you are looking to do this on and where you expect to see the result.&nbsp;Are you able to please provide some specifics so we can advise on the best way forward? E.g. on what tab and which cells you want something in, etc.&nbsp;CheersDamien

paul_julz · Answer

Hi there&nbsp;In particular, I am looking at all dollar values on the parts pricing tab and the glass price list.&nbsp; Does that make sense?&nbsp;Cheers&nbsp;Julie

damien_rosario · Answer

Hi&nbsp;paul_julz&nbsp;&nbsp;Yup got you now. I'm not a maths expert, but wouldn't increasing values in column Z, AA, AB, AC achieve that as the other fields in GlassList tab reference them?&nbsp;Similar suggestion for Parts Pricing tab values in say column T.&nbsp;CheersDamien

Forum Discussion

Applying A Price Increase

7 Replies

Resources