IF formula cant get to work





I am currently using this formula it does work but doesnt do what i need it to:

=IF(E17,”Complete”,”In Progress”)

currently its just selecting the true or false information and using conditional formatting im changing the colours of the cells,


However, i want to include another condition which i cannot seem to get to work this is:


if the completed by date is greater than todays date which i already have in a cell i want it to override the true or false and put incomplete, ive tried various things and cant seem to get it working can anyone help!!?


thanks in advance

By: Adam

Leave a Reply

Your email address will not be published. Required fields are marked *