Share via

IFS Formulas

Anonymous
2024-08-02T18:56:59+00:00

in an IFS formula, there will be a column that changes as more data is entered. this is how I will make it work to fill in another column. Example: ( If C3="c", "blue, If C4="n", "red") How to I adjust the formula to step down in column C?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rich~M 20,370 Reputation points Volunteer Moderator
    2024-08-02T19:32:13+00:00

    You asked about an IFS function, but the syntax you reference is incorrect. Here is the correct syntax.

    *=IFS([Something is True1, Value if True1,Something is True2,Value if True2,*Something is True3,Value if True3)

    These are combinations of two things--the test and the result--each after the other. Each of these combinations will refer to the same cell and whichever condition is true will determine the result of the formula. Here is an example patterned after your description entered in D2 in the screenshot below and filled down.

    =IFS(C3="c","blue",C3="n","red",C3="d","yellow",C3="f","green")

    Was this answer helpful?

    0 comments