if-then function

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I need to do the following:

=IF(Y35=Y36,copy y35, paste values y38,"false")

I feel sure the "copy y35, paste values y38" is
incorrect but I don't know how to correct it.

Also I have never been to do an "if, then goto" type
function.

Help much appreciated.
Thanks
 
Tom,
Are you saying that if Y35 equals Y36 then you want to copy Y35 into Y38? If so, then use this formula in Y38:

=IF(Y35=Y36,Y35,"")

The double quote will make Y38 blank if the condition is false. If you have some other formula or number just replace the "".

Good Luck,
Mark Graesser
(e-mail address removed)


----- Tom wrote: -----

I need to do the following:

=IF(Y35=Y36,copy y35, paste values y38,"false")

I feel sure the "copy y35, paste values y38" is
incorrect but I don't know how to correct it.

Also I have never been to do an "if, then goto" type
function.

Help much appreciated.
Thanks
 
A formula like this wont ever copy and paste values from one cell to
another. What you would do is put this formula in the cell where you want
the value to be "pasted", which is Y38-- like:

=IF(Y35=Y36,Y35)

Functional "copying" is accomplished with the "Y35" part of the formula,
i.e.,. bringing the value from Y35 to the cell where the formula is entered
if Y35=Y36 is true.

You don't necessarily need to specify "false"-- that is the default
'response' if the condition is not true (i.e. Y35<>Y36), but it will look
like FALSE. Youl'll still be able to manipulate Excel's automatic FALSE as
you would any other text string (as would be if you kept "false" in your
formula).
 
Back
Top