google sheets if then formula multiple conditions

When parenthesis are used to enclose several operations and functions inside a function they are considered as a parameter of the function that contains them.Ī common practice is to put the inner IF() as the value_if_false, but it could be done in many ways. In Google Sheets the functions parameters are separated by commas (or semicolons if your spreadsheet uses comma as decimal separator). the second example is that the logical_expression of the outer IF() do not return TRUE or FALSE.the first example provided is that the outer IF() has too many parameters.IF(logical_expression, value_if_true, value_if_false) IF() function should have two parameters and optionally a third one.

The problem in the examples provided are the parenthesis. Is there any way I can simply include multiple IF statements in the same cell which will work for my code? This also leads to a formula parse error. It is clear you cannot simply separate if statements with commas.

There are four possible hex values at the moment so I was trying to put four different IF statements in the same cell, so its value is changed based on this. So the value of the cell should change based on the hex code which is obtained from the colour of the first cell. This adjacent cell gets its value from the colour of the cell adjacent to it using the formula from this Quora answer. I am attempting to change the value of a cell in Google Sheets based on the value of an adjacent cell.

Google sheets if then formula multiple conditions