Need help with IF statement

p amendolara

Want to have RYGB symbol auto-populate based on following:

If Status = Complete, set to Blue

If Days Late greater than 29, set to Red

If Days Late < 15, set to Green

Otherwise set to Yellow

Christian G.

Write that into seperate IF statement then join them together.

if(status@row="Complete","Blue",else...)

if([Day Late]@row>29,"Red",else...)

if([Day Late]@row<15,"Green","Yellow")

All joined together you get:

=if(status@row="Complete","Blue",if([Day Late]@row>29,"Red",if([Day Late]@row<15,"Green","Yellow")))