Using IF function to copy.

D

Dev_prashad

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.
 
M

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
 
Top