A
Alien
=IF(M6>0.9,IF(M6<9,1.06,VLOOKUP(M6,$P$1:$Q$16,2)))
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
You could use the Find-Next button in that dialog to step over those that
you don't want to change. Not perfect, but probably quicker than manually.
Other than that it is VBA.
you don't want to change. Not perfect, but probably quicker than manually.
Other than that it is VBA.
A
Alien
Select the cell you want to amend and any blank cell. Then Ctrl H will only
act on those 2 cells.
Andy
M
Myrna Larson
Hi, Bob:
In this situation, if an adjacent cell is blank, I've found it easiest to select the target cell
and the adjacent blank cell. Then the replacement will work only on those cells. If there's no
adjacent blank cell, it may or may not be worthwhile to insert a blank row or column, do the
replacement as described, then delete that added row/column.
In this situation, if an adjacent cell is blank, I've found it easiest to select the target cell
and the adjacent blank cell. Then the replacement will work only on those cells. If there's no
adjacent blank cell, it may or may not be worthwhile to insert a blank row or column, do the
replacement as described, then delete that added row/column.
B
Bob Phillips
Myrna,
I was unaware of that trick.
Even hearing it, I don't get it. Why/how does it work?
--
HTH
Bob Phillips
I was unaware of that trick.
Even hearing it, I don't get it. Why/how does it work?
--
HTH
Bob Phillips
Myrna Larson said:Hi, Bob:
In this situation, if an adjacent cell is blank, I've found it easiest to select the target cell
and the adjacent blank cell. Then the replacement will work only on those cells. If there's no
adjacent blank cell, it may or may not be worthwhile to insert a blank row or column, do the
replacement as described, then delete that added row/column.