Alter a formula from a certain cell reference to cell on the left.

**danbates** · 12-06-2018, 03:28 PM

Hi,

I was wondering if it was possible to change the following formula:

Please Login or Register  to view this content.

Instead of the cell being D243, is it possible to have it so it looks at the cell to the left?

Thanks

Dan

**dosydos** · 12-06-2018, 03:33 PM

without seeing your workbook i can only speculate.
Yes you can change D243 to C243, will it work correctly, i dont know.

If you want to do this i would suggest selecting the cell.
Then go to Home Ribbon and Select Find and then select Replace (or press ctrl h)
type in D243 in the "Find what" tab
Type C243 in the "Replace with"
select Replace

If you wanted a more complicated formula where you keep the D243 reference but you want it still to get one cell to the left you can add an offset formula which i provided below..

Formula:

Please Login or Register  to view this content.

**danbates** · 12-06-2018, 04:16 PM

Hi dosydos,

Thank you for your reply.

Here is a link to another forum which I have posted on and it has a little more information.

https://www.mrexcel.com/forum/excel-...alidation.html

Thanks

Dan

**dosydos** · 12-06-2018, 04:24 PM

now i am confused, are you looking for help with the question on the other site? or are you still looking for a way to reference the cell to the left with the original formula you gave? Did either of the two options i listed in post #2 help at all?

**danbates** · 12-06-2018, 05:24 PM

They are both supposed to be the same but now I can see I haven't explained it very well on here.
I was in a rush at work, sorry.

Alter a formula from a certain cell reference to cell on the left.

LinkBack

Thread Tools

Rate This Thread

Display

Alter a formula from a certain cell reference to cell on the left.

Re: Alter a formula from a certain cell reference to cell on the left.

Re: Alter a formula from a certain cell reference to cell on the left.

Re: Alter a formula from a certain cell reference to cell on the left.

Re: Alter a formula from a certain cell reference to cell on the left.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] formula to reference cell on the left and add +1

Indirect Sheet reference with cell reference left function and text

Can a custom function alter the formula of its own cell?

Reference to cell directly to the left

Alter value in one cell alter value in multiple cells

Alter a pivot table cell driver by reference

Returning with cell on right/left of a reference

Bookmarks

Bookmarks

Posting Permissions