IFS OR FUNCTION IN EXCEL

[SUDHAKAR-FRONTIER]

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.!!!.

[#2]

@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?

[#3]

@Riny_van_Eekelen 

not colour  Riny, its green, amber, red want to display..

[#4]

YES

[#5]

@SUDHAKAR-FRONTIER 

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. 

[#6]

@bovasclion 

Yes, This same kindly help me amber condition formula..

[#7]

@SUDHAKAR-FRONTIER 

Check this, worksheet is also attached