Forum Discussion
Determine training compliance with IF/IFS function(s)
Hi, I wonder if someone can help with the following: I'm trying to determine mandatory training compliance for the first quarter of 24/25 and an excerpt of my massive spreadsheet looks like the b...
After posting my reply, I realised the example I tried to copy has been completely messed up in terms of format! I am trying to post a screenshot of the spreadsheet but can't seem to be able to do that either! Apologies, I hope you are able to see the inconsitency in the results of the formula
Hi, thank you very much for the help and taking the time to respond. I have finally resolved it by adding one more condition to each nested IF function. I ended up with a fairly long formula, and I need to remember to change the date at the end of each quarter, but it's giving me the correct results!
I copy it here in case anyone finds it useful: helpful: =IF(IF(AND(M2<>"",M2>DATEVALUE("30/06/2024")),4,IF(AND(K2<>"",K2>DATEVALUE("30/06/2024")),3,IF(AND(I2<>"",I2>DATEVALUE("30/06/2024")),2,IF(AND(G2<>"",G2<=DATEVALUE("30/06/2024")),1,0))))>=F2,"Compliant","Not compliant")
Many thanks again!
Anastasia