Jan 18 2021 07:57 AM
Dear Friends,
help me on below.
i have 2 years data like 2019 and 2020,
So here i wanna to apply 3 condition..
GREEN, AMBER, RED
GREEN Values should be more then <=0.50,
AMBER Values should be less then >=0.05,
RED values should be less then >=0.01 including minus values also have to met..
so here i have to use IFS() AND OR() function
when i am using formula green(2019 or 2020 or both<=0.5) .
amber (2019 or 2020 or both>=0.5), Red(2019 and 2020 >=0).
Please help me on formula.!!!.
Jan 18 2021 08:31 AM
@SUDHAKAR-FRONTIER I believe you received an explanation of the basics for these kind of calculations here:
https://techcommunity.microsoft.com/t5/excel/ifs-negative-values-error/m-p/2066337
Do you now want to conditionally format the cells with a colour (Green, Amber or Red) in stead?
Jan 18 2021 05:34 PM
not colour Riny, its green, amber, red want to display..
Jan 25 2021 08:40 PM
Pls check the conditions again,
Green - x >=0.50
Red - x <= 0.01
Amber - x between 0.02 to 0.49
If this conditions are correct then you can easily do this with conditional formatting.
Jan 25 2021 08:43 PM
Jan 25 2021 09:01 PM - edited Jan 25 2021 09:03 PM