Forum Discussion
Combining If AND OR Formulas
How would you set up a formula that combines if, and,or. What I want to accomplish in one column is to put the date when a worker accumulates 960 work hours and when he accumulates 1920 work hours. ...
Give this a try:
=IF(OR(AND(BA3>=960,BA2<960),AND(BA3>=1920,BA2<1920)),CL3,"Not Applicable")
Thanks!