IF formula to include multiple conditions

Hi,

I need the following formula to also include the following if possible - "=IF(M2="Completed","Green")

=IF(M2="","Green",(IF(M2<TODAY(),"Red",IF(M2<TODAY()+3,"Amber","Green"))))

Thanks

try

=IF(OR(M2="",M2="Completed"),"Green",(IF(M2<TODAY(),"Red",IF(M2<TODAY()+3,"Amber","Green"))))

That worked perfectly, many thanks.

You're welcome.