If/and statements

I’m trying to write a statement to say;


If the cell in B1 is greater than 10,000, return Check. 

If the cell in B1, is between 1,000-10,000 and cell C1 is less than 500, then also return Check

If not, OK


Can anyone help?



By: Jo

Leave a Reply

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