Replacing formula while keeping relative cells.

[namy77]

Good afternoon,

Currently, I have sheets that calculate different prices and their upcharges.

For example

Base price: A1: $45
B1: Upcharge 1: A1+$5
C1: Upcharge 2: A1+$10

Is there a quick way to replace this formula structure.. say A1*1.3+$5 for Upcharge 1 and A1*1.5+10 for upcharge 2?

Find and replace won't work, because A2, A3 etc... also have formula and would need to be changed as well. Thanks!

[leelnich]

Hi, namy77- I'm not sure what you're trying to achieve. Could you upload a sample workbook?
Please remove any personal or proprietary information.
Try to use your original layout so our solutions fit your workbook.
Include “realistic” data showing any variations the code or formula must address.
Highlight the formula cells and simulate some results to help us visualize what you want.

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now click Browse, find your file, then click Upload. Simple!