|So I have been asked to make a spreadsheet for my lab that keeps track of our reagents and when they are opened, tested, and expire.|
I want to make a single column that will check the dates in previous columns to give a final 'OK' or 'Do Not Use'.
So far I am only able to use one 'IF' statement, I can't seem to get multiple 'IF' statements to work.
Right now, I am using "=IF(F2>=TODAY(),"OK","DO NOT USE")"
F2 is the expiration date, so this is checking to make sure that the product is not expired. However, I also need to check that the product has been tested before we use it. Therefore, I need another 'IF' statement to test that there is a date tested in G2 (i.e. that it is not blank).
So I *think* I need a nested IF statement that will check both of these conditions, and as long as the conditions are true (that the expiration date is >=Today, and that G3 is not blank), it will return simply as 'OK', or if false as 'Do Not Use'.
Thanks for any help/advice!