Traffic Light Conditional Statement

[#1]

I am having trouble getting my traffic light to display colors properly based on an IF condition

I would like the light to turn green if the actual/budget is greater than 85% and red if it's below 75%. Below is what I tried to make work.

if((Sum([Amount Actual])/Sum([Amount Budget]))>=.85,1
if(Sum([Amount Actual]/sum([Amount Budget])<.75,3,2)

Comments please!!!

[Anonymous]

Can only check syntax, not the logic... You have two closing parenthesis missing (bold):

if((Sum([Amount Actual])/Sum([Amount Budget]))>=.85,1
if(Sum([Amount Actual])/sum([Amount Budget])<.75,3,2))