Paste Special; Pasting only the formulas
At 0:50 when using the paste special to paste only the formulas; When pasting SUM(D9:D10) why doesn't it show the actual summary of the numbers existing in the cells D9 and D10? Why is it showing 0 instead?
5 answers ( 0 marked as helpful)
Hi MIchael,
The cells in D9 and D10 are empty and hence the formula shows 0.
Best,
Ned
Oh ok, it seems that I identified the cells incorrectly. Thanks for the quick reply.
How many Project should to as a beginner in Excel , SQL , Poer Bi - Tablue, R Basic , Python Basics ?
What is the concept of "formula" while using special paste?
How come the formula 136 and 129 came for the given exercise?
Hello,
A formula is the operation that we've specified in the formula bar.
Best,
Ned