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?

 

Thanks

By: Jo

Leave a Reply

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