Forum Discussion

Match811's avatar
Match811
Copper Contributor
Apr 30, 2019

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

excel

2 Replies

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Apr 30, 2019

    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

    • Match811's avatar
      Match811
      Copper Contributor
      May 01, 2019

      Hi Damien_Rosario 

       

      Thank you very much for your help.

      The formula worked perfectly

       

      Kind regards

       

      Match811

Resources