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. I am able to do the 960 part with success. I want to see if I can put the 1920 work hours in the same formula which is the OR part. This involves building a cumulative column which I have successfully done. In this scenario the worker may not hit 960 or 1920 hours exactly but the previous week(row) the worker did not hit 960. Here is the formula for the 960 part =IF(AND(BA3>=960,BA2<960),CL3,"Not Applicable")
How can I put on OR formula to account for the 1920 part? Thank You Kindly Glenn!
1 Reply
- Chris-RessConsultingBrass Contributor
Give this a try:
=IF(OR(AND(BA3>=960,BA2<960),AND(BA3>=1920,BA2<1920)),CL3,"Not Applicable")
Thanks!