IF function
This is the formula to calculate if assessments have happened, going to
happened or hasn't happened
=IF(NOW()-AF2=0<365,"ASSESSMENT CARRIED OUT THIS
YEAR",IF(NOW()-AF2<0,"ASSESSMENT PLANNED FOR THIS YEAR BUT NOT CARRIED
OUT",IF(NOW()-AF2365,"ASSESSMENT NOT PLANNED OR FAILED TO HAPPEN",)))
Every time I change the figure to test the function the response is
"ASSESSMENT CARRIED OUT THIS YEAR" regardless of the figure it's working out.
Where am I going wrong?
|