IF formula cant get to work

 

 

showing

 

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 *