Excell

Copper Contributor

 

hi all,

Can anyone please help with my Excell query.

I want to copy the vaule in D3 to I3 if cell E3 has a Y in it

 

Thanks

2 Replies

Hi @Match811 

 

Try this in cell I3:

 

=IF(E3="Y",D3, "")

 

So if E3 is yes, the contents of D3 will be put into I3, if it is not then then I3 is blank.

 

Cheers

Damien

Hi @Damien Rosario 

 

Thank you very much for your help.

The formula worked perfectly

 

Kind regards

 

Match811