Red Amber else Default

[bobbydave]

I am writing some code at the moment to say that

When a value is higher than its target, the value turns green and when a value is less than its target, value turns red.

But what if there is no target, the values should stay default (black).

=if(

(if(Unit = '%', num(avg([Value]), '#,##0%'),

   if(Unit = 'Days', num(avg([Value]), '#,##0'),

  num(sum(Target), '#,##0'))))

>= 

(if(Unit = '%', num(avg(Target), '#,##0%'),

   if(Unit = 'Days', num(avg(Target), '#,##0'),

  num(sum(Target), '#,##0')))),

  vGreen, vRed)

Is there a way of adding if target is blank, the values stay black

Target	Value	Value
5	7	3
6	3	8
	7	7

[alexandros17]

something like this:

=If(IsNull(sum(Target), rgb(255,255,255),

if(

(if(Unit = '%', num(avg([Value]), '#,##0%'),

if(Unit = 'Days', num(avg([Value]), '#,##0'),

num(sum(Target), '#,##0'))))

>=

(if(Unit = '%', num(avg(Target), '#,##0%'),

if(Unit = 'Days', num(avg(Target), '#,##0'),

num(sum(Target), '#,##0')))),



vGreen, vRed)
)

[bobbydave]

Doesnt seem to like that.

[alexandros17 · Accepted solution]

just manage the first expression

If(IsNull(sum(Target),

[giakoum]

why don't you use visual cues?