How to change formula ?

[etnys]

Hi All,

Can You please help me to change formula cells numbers:

=IF('147'!$Q$5=1;'147'!$D$13;0) into
=IF('148'!$Q$5=1;'148'!$D$13;0)
: :
: :
: :
: :
=IF('190'!$Q$5=1;'190'!$D$13;0)

147, 148 ..... 190 is the cell number

Right now I am changing it manualy in every single cell. Can I do it with some kind of tool ?

thanks
JD

[TMS]

When you say "cell", do you mean "row"?

In which case:

Please Login or Register  to view this content.

Regards, TMS

[FDibbins]

Hi and welcome to the forum

147, 148 ..... 190 is the cell number

That looks like the sheet name?

If so, try this....
=IF(INDIRECT("'"&146+ROW(A1)&"'!$Q$5")=1,INDIRECT("'"&146+ROW(A1)&"'!$D$13"),0)