I need help on a project that I have been working on. I need cell4 to have 3 inputs based on cell1,2 and 3. If cell1 has value, cell4 will show ABC. IF cell1 & 2 has value, cell4 will show DEF and if cell1, 2 & 3 all has values, cell4 will show GHI.

Can someone help me with a code for this?

Any help will be much appreciated.

  • can you share a link to your google sheets ? Commented Feb 7, 2022 at 13:22

1 Answer 1


is this result correct for you? enter image description here

that result could be obtained with:

=IFS(and(A2:A<>"",B2:B<>"",C2:C<>""),"GHI",and (A2:A<>"",B2:B<>""),"DEF",A2:A<>"","ABC",A2:A="","")

(calculation to be extended to the cells of the desired rows)

this formula uses comma as separator... you can change ALL commas with semi-colon if your system needs it

  • Hi, Thank you for answering my question. However what I need to have is Cell4 to be dynamic which changes the input once cells 1-3 has been filled up. So when I input a value for cell1, the cell4 would show ABC then once cell2 has value, cell4 would show DEF and once cells 1 to 3 has been filled with value, cell4 would show GHI. Thank you for helping me on this. Hope you have a wonderful day Daniele!
    – Rei
    Commented Feb 7, 2022 at 23:03
  • your comment does not clarify what you actually want to achieve, rather it complicates it. Please attach a screenshot of what you want
    – Daniele
    Commented Feb 8, 2022 at 5:22
  • My apologies. I'm new to this and during my time there was never a need for us to do this stuff. I think I can try out your formula on the initial photo that you have sent. Would you be so kind to share how did you do it? Thanks so much for your patience.
    – Rei
    Commented Feb 8, 2022 at 6:54
  • @rei I updated my answer
    – Daniele
    Commented Feb 8, 2022 at 20:35
  • Thank you so much this is great help for me and to my team.
    – Rei
    Commented Feb 9, 2022 at 1:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.