View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Didn't you get this answered at one of your other posts?

merlin68 wrote:

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.


--

Dave Peterson