Hi
Just wondering if ther is a quick way to change a number of the same cell references in one go? for exampe in this formula below i want to change the $C$5 to another one like $F$5 but the way I'm doing it at the moment is to type it in 8 times... Anyone know if could change all 8 instances of it in one go?
=IF(Sheet2!E7=$C$5,2,IF(Sheet2!E7=$C$5+1,1,IF(Sheet2!E7=$C$5-1,3,IF(Sheet2!E7=$C$5-2,4,IF(Sheet2!E7=$C$5-3,5,IF(Sheet2!E7=$C$5-4,6,IF(Sheet2!E7=$C$5-5,7, IF(Sheet2!E7>$C$5+1,0))))))))
Thanks in advance..
Just wondering if ther is a quick way to change a number of the same cell references in one go? for exampe in this formula below i want to change the $C$5 to another one like $F$5 but the way I'm doing it at the moment is to type it in 8 times... Anyone know if could change all 8 instances of it in one go?
=IF(Sheet2!E7=$C$5,2,IF(Sheet2!E7=$C$5+1,1,IF(Sheet2!E7=$C$5-1,3,IF(Sheet2!E7=$C$5-2,4,IF(Sheet2!E7=$C$5-3,5,IF(Sheet2!E7=$C$5-4,6,IF(Sheet2!E7=$C$5-5,7, IF(Sheet2!E7>$C$5+1,0))))))))
Thanks in advance..