Forum Discussion
Excell
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
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
Thank you very much for your help.
The formula worked perfectly
Kind regards
Match811