How can I use the Find what: =IF to Replace with: =INT(IF? --- My column has 400 cells.

[arthurz11]

 

[Cubist]

Why don't you manually change the formula in C1 and copy down?

 

[arthurz11]

Why don't you manually change the formula in C1 and copy down?

That was just a sample because I have dollar signs on my equations. Here is one of the actual equations: =IF(OR($B$5=$C$27,$B$5=$D$27,$B$5=$E$27,$B$5=$F$27,$B$5=$G$27,$B$5=$H$27,$B$5=$I$27,$B$5=$J$27,$B$5=$K$27,$B$5=$L$27,$B$5=$M$27,$B$5=$N$27,$B$5=$O$27,$B$5=$P$27,$B$5=$Q$27,$B$5=$R$27,$B$5=$S$27,$B$5=$T$27,$B$5=$U$27,$B$5=$V$27),J1683,0) I have four columns that have over 400 cells that starts differently from all the other columns. I just realized that I needed the integer (INT) formula for each cell. I remember something about using the Find and Replace feature where you can use some kind of symbol to ignore the letters and numbers in between and it will replace =IF to =INT(IF......) so it will add another close parenthesis. I was hoping someone from Mr. Excel would know. I thought it was the "*" but that didn't work. For example: Find what: =IF to Replace with : =INT(IF*). I thought this means that it will replace it and add the close parenthesis at the end of the formula. But obviously, the symbol "*" was not it.

 

[Cubist]

Your formula can be simplified to this.

=INT(IF(SUM(--($C$27:$V$27=$B$5))>0,J1683,0))

 

[Phuoc]

Or try:

=IF(COUNTIF($C$27:$V$27,$B$5)>0,INT(J1683),0)

 

[arthurz11]

Your formula can be simplified to this.

=INT(IF(SUM(--($C$27:$V$27=$B$5))>0,J1683,0))

I really don't want to revised the formula. I just want to use the Find and Replace feature. Right now there's like a ball bouncing back and forth in my brain. Will contact tomorrow. Thanks.