Forum Discussion

RArnold04's avatar
RArnold04
Copper Contributor
Jun 14, 2021
Solved

Excel365 Formula

Hi Folks, Looking for a formula for Excel365.  I had it before and my computer crashed and I lost it.   If A100 is 1 than S100=K100   I'm missing something keep getting the common error.  I thin...
  • HansVogelaar's avatar
    Jun 14, 2021

    RArnold04 

    Select cell S100.

    Enter the formula  =IF(A100=1,K100,"")

Resources