Hi,
This is my first posting, so please be gentle. I'm not a beginner, but also not an expert. I want to create a traffic light indicator based on the following, and am able to get all the elements to work with the exception of the (0,1). Could someone out there please help !!
The trafficlight is based on 2 cells
A1 0 0 1 1 20 20
A2 0 1 1 2 19 15
if row A1=0 and row A2=0 then print "W"
if row A1=0 and row A2>0 then print "G"
if after that
if row A1=row A2 = or > 0 then print "G"
if row A1/row A2 < 0.8 (80%) then print "R"
if row A1/row A2 <1 (but greater than 0.8) then print "A"
I hope that it is clear.There's a lot of sport on this weekend and I don't want to spend the weekend re-hacking the spreadsheet about because I cannot workout a lousy "IF" statement.
Many thanks
Bookmarks