How to replace one variable in a long function

[bankerguy]

Hi all!!

I thought that Substitute function would work but it did not.

I have the following equation Entered in cell B38

if(A1>10,"YES","NO",)


Now if i want cell B39 to be exactly the same as B38 i could just copy and past the forumla...BUT instead of A1, i want it to say B1... is there a short cut??

My actual equation is much much longer than the one above so to go in and manually change every "a1" would take forever. Also, changing A1 to B1 is the only variable substitution i want... but it occurs many times..

Thanks

[TMS]

Copy the formula (from the formula box) and paste it. Then select the cell and do a replace all.

Regards, TMS

[bankerguy]

Thanks...i knew there was an obvious and easy way to do it!!

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.