View Single Post
  #1   Report Post  
merlin68
 
Posts: n/a
Default Function IF / test / Picture result

PRODUCT ORD ALLOC EG STATUS
Tyres 100 300 200 ACCEPT

Pls try to help me - I need to put "traffic lights" picture into field
STATUS instead of ACCEPT or STOP. How can I do it ? The field STATUS is
calculated on test

=IF(G8<0;"STOP";IF(G70;"ACCEPT";"STOP"))

where G8 is EG column and showing to me if I can accept more orders or not.