Formula Question

[Tom G]

In the following formula:

=IF($Y$2="","",IF(T24=$Y$2,(U24*0.5*$Y$3),IF(V24=$Y$2,(W24*0.5*$Y$3),IF(X24=$Y$2,(Y24*0.5*$Y$3))))-(U24+W24+Y24))

How do I change all of the $Y values to X. Is there a way to do that
all at one time?

Thanks,

Tom

 

[Ron Rosenfeld]

In the following formula:

=IF($Y$2="","",IF(T24=$Y$2,(U24*0.5*$Y$3),IF(V24=$Y$2,(W24*0.5*$Y$3),IF(X24=$Y$2,(Y24*0.5*$Y$3))))-(U24+W24+Y24))

How do I change all of the $Y values to X. Is there a way to do that
all at one time?

Thanks,

Tom

Select the cell.
Edit/Replace
Find: $Y
Replace with: X

Replace
Close

should do it.


--ron

 

[jcorbett]

You could just highlight all the cells with that formula and do a Find
(Control-F) and replace all the $Y with $X.

Jim

 

[Guest]

Hi Tom

Highlight this cell and any other cells you want to do this to. If you only
want to do this on one cell then highlight this cell and any other blank cell.

Then Ctrl+H --> Replace: Y$ --> With: X$ --> Replace All

Hope this helps
Jon