Forum Discussion
SUDHAKAR-FRONTIER
Aug 04, 2021Brass Contributor
IF function error
Dear Friends, Kindly help me the below error, i have written the IF condition like 0.50 > GREEN, Refer the column - j2>=0.50, t2>=0.50, "green", 0< RED, Refer the column - j2<=0, t2<=0, "re...
SUDHAKAR-FRONTIER
Aug 04, 2021Brass Contributor
Riny_van_Eekelen
Aug 04, 2021Platinum Contributor
SUDHAKAR-FRONTIER An image is no good. I'd need the file to look at.
- SUDHAKAR-FRONTIERAug 04, 2021Brass Contributor
Please find the Attached file.
If possible kindly help (b2<=10.00, c2<=10.00) "GREEN +",
Between 50 to 10 need to display Green.
- Riny_van_EekelenAug 04, 2021Platinum Contributor
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.
- SUDHAKAR-FRONTIERAug 04, 2021Brass Contributor
Still same error, Suppose the highlighted cases to be Amber but its coming RED. same attached below