B
bluesifi
Hi
If in a formula you are working out if something is greater 2 hours, you pur
2/24. How do you express it is you was 1 day or 2 days.
ie =IF(AND(N2-E2<2/24,D2="HIGH"),"YES",IF(AND(N2-E2< ?????,D2="MEDIUM")
I wand ????? to equal 2 days.
Joanne
If in a formula you are working out if something is greater 2 hours, you pur
2/24. How do you express it is you was 1 day or 2 days.
ie =IF(AND(N2-E2<2/24,D2="HIGH"),"YES",IF(AND(N2-E2< ?????,D2="MEDIUM")
I wand ????? to equal 2 days.
Joanne