doubt
 

wht will the result of formula'=B2+$C$3' in c2 when copied to A3

doubt
 

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.
--
David Biddulph

"nibu" wrote in message
...
wht will the result of formula'=B2+$C$3' in c2 when copied to A3

doubt
 

On Aug 15, 2:30 am, nibu wrote:
wht will the result of formula'=B2+$C$3' in c2 when copied to A3

It will change one of those references into a #REF! error.

Is this a silly-Excel-knowledge contest? Do I win the prize?!?!