doubt

D

David Biddulph

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

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?!?!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas across columns 2
Avoiding auxiliary cells 0
Same forumula returns both 0 & N/A 2
Need help calculating probabilities 7
Sumproduct formula problem 5
Sumproduct in matrix means 3
Hyperlinks with lookups 0
concatenate with arrays 7

Top