Forum Discussion
IF function error
SUDHAKAR-FRONTIER An image is no good. I'd need the file to look at.
Please find the Attached file.
If possible kindly help (b2<=10.00, c2<=10.00) "GREEN +",
Between 50 to 10 need to display Green.
SUDHAKAR-FRONTIER Well, with this data it seems that OR in all three conditions works as intended. It didn't when I replicated the data from your initial data set.
Still same error, Suppose the highlighted cases to be Amber but its coming RED. same attached below
SUDHAKAR-FRONTIER Your problem is that these rows qualify for two if the three criteria when you use OR. The IFS function stops evaluating the formula as soon as a criteria is met.
When you use AND, some rows will return #N/A as none of the criteria are met. Make sure that all possible criteria are correctly set and that there is no overlap between them.