Hi Guys,
I can't figure out this formula:
Status output
If cell value is between Min/Max Targets = Green
If cell value is below/above Min/Max Targets = Red
If cell is equal to value value = Yellow
Trend output
If cell value is Increasing = Up
If cell value is decreasing = Down
If cell value is equal to previous value = Sideway / otherwise: Up or Down
I can't figure out this formula:
Status output
If cell value is between Min/Max Targets = Green
If cell value is below/above Min/Max Targets = Red
If cell is equal to value value = Yellow
Trend output
If cell value is Increasing = Up
If cell value is decreasing = Down
If cell value is equal to previous value = Sideway / otherwise: Up or Down
Value | Min target | Max target | Status | Trend |
79% | 85% | 95% | Red | Down |
93% | 85% | 95% | Green | Up |
85% | 85% | 95% | Green | Sideway |