S Spiky Aug 15, 2008 #2 wht will the result of formula'=B2+$C$3' in c2 when copied to A3 Click to expand... It will change one of those references into a #REF! error. Is this a silly-Excel-knowledge contest? Do I win the prize?!?!
wht will the result of formula'=B2+$C$3' in c2 when copied to A3 Click to expand... It will change one of those references into a #REF! error. Is this a silly-Excel-knowledge contest? Do I win the prize?!?!