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.