Use of Paste Special - Operation
I got the result 30. correct...!
"Gord Dibben" wrote:
Have you tried using the operation options to see what happens?
They add, subtract,multiply and divide the selected cell(s) by what you have
copied onto the clipboard.
i.e. you have 10 in A1
You have 3 in B1
Copy B1 and paste specialmultiply to A1
What result do you get?
Gord Dibben MS Excel MVP
On Tue, 10 Oct 2006 00:00:02 -0700, Avadivelan TCS
wrote:
Hi All,
In the PASTE SPECIAL ,what is the use of
OPERATION(Add,Sbtract,Multiply,Divide)
radio button. can anybody expliain with example.
Thanks in advance for your reply.
|