This content has been marked as final.
Show 2 replies
-
1. Re: IF calculation with AND
Adrian Abarca Sep 3, 2012 4:15 AM (in response to Stephen Davie)Try this:
IF SUM([Positive Outcomes (PO)]) <= 69.9 THEN 'Red'
ELSEIF SUM([Positive Outcomes (PO)]) >= 0.7 AND SUM([Positive Outcomes (PO)]) <= 0.85 THEN 'Amber'
ELSE 'Green' END
-
2. Re: IF calculation with AND
Stephen Davie Sep 3, 2012 5:48 AM (in response to Adrian Abarca)Brilliant - works a treat! Goodness know's why I didn't try that in the first place - I'll blame Monday morning-ness!
Thanks a lot.