Jul 19 2022 09:28 PM
I am trying to format a document to auto fill based on the content of 3 other cells
for example;
if D9, E9 and F9 (using dropdown list) are all equal to "yes" G9 will auto populate to "yes", But
if any D9, E9, or F9 contain either "in Progress" or "no" G9 will auto populate to Either "In progress" or "no"
i feel like this should be conditional formatting however cant figure out how to have the cells auto populate how i want them.
Ay help would be greatly appreciated.
Jul 19 2022 09:41 PM
@Jim_Martin Try this:
=IF(COUNTIF(D9:F9,"yes")=3,"yes",IF(COUNTIF(D9:F9,"no")<>0,"no",IF(COUNTIF(D9:F9,"In Progress")<>0,"In Progress", "-")))
Not very elegant, but it works. Note that your screenshot suggest that when both No and In Progress occur, that No should be the end result.
Jul 20 2022 06:23 PM
@Riny_van_Eekelen Thanks for your help, that works like a charm.
Jul 20 2022 06:59 PM
Jul 20 2022 07:49 PM
@Jim_Martin That would be:
=IF(G9="yes",C9,"")
meaning as much as, "If condition is met then value if true, otherwise value if false"
Jul 20 2022 08:31 PM