IF statement Conundrum

[kudakaswa14]

Hi All,

I have two columns. Column A has numbers in some rows while Column B has a drop down which allows someone to classify the numbers in Column B e.g. asset, expense, revenue etc.

I would like a formula which will return "Please complete SCOA classification in full" where there is a number in column A but individual hasn't classified in column B and where all cells that have numbers in A have been classified to return "SCOA classification complete".

Its basically a check which ensures that the spreadsheet is complete. This will come on the dashboard.

 

[kudakaswa14]

How about

=IF(COUNT(A:A)>COUNTA(B:B),"Please....","")

Thanks for this I tweaked it a bit but its now working just like I wanted. Thank to everyone else for your help