wht will the result of formula'=B2+$C$3' in c2 when copied to A3
D David Biddulph Aug 15, 2008 #2 Why don't you try, and let us know? What would you expect it to be? What do you want it to be? If you don't understand what it's doing, look up absolute and relative addressing in Excel help.
Why don't you try, and let us know? What would you expect it to be? What do you want it to be? If you don't understand what it's doing, look up absolute and relative addressing in Excel help.
S Spiky Aug 15, 2008 #3 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?!?!
