Using IF function to copy.

[[email protected]]

How can I copy data from one cell to another only if a certain criteria is
met using the IF function? For example, I want to copy data from cell A20 if
the cell A19 the a specific word in it.

[Max]

Something like ..

In B20: =IF(A19="Yes",A20,"")

B20 will return the contents of A20
if A19 contains the word: Yes,
otherwise blank: "" will show in B20
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
[email protected] <[email protected]@discussions.microsoft.com>
wrote in message news:[email protected]...
> How can I copy data from one cell to another only if a certain criteria is
> met using the IF function? For example, I want to copy data from cell A20
if
> the cell A19 the a specific word in it.