Any column below the stock Level, status become to red.

richard_uy

Hi,

As per the attached and formula, How can i add the formula if Week 15,16,17~52 any column below the stock Level, status become to red.

I'm only know the formula for single column. 

=IF(ISBLANK([Stock Level]2), "Yellow", IF([Stock Level]2 <= [Week 14]2, "Green", IF([Stock Level]2 > [Week 14]2, "Red", "")))

 

Thanks in advance.

p_bureau

Hi,

 

Maybe you could use COUNTIF? Something like :

 

"=IF(COUNTIF([Week 14]2: [Week 52]2 ,"<"+ [Stock Level]2)>0,"Red","Green")"

 

That means : if there is more than 0 week that are > Stock Level, then Red. Else Green.

 

Does this helps?

 

Paul.