Can anyone tell me why this IF statement isn't working?
I need it to only work when there is specifically "st marys house" in the B125 field and one of the following from the H125 field.
IF(B125="st marys house"(and(or,H125="Half Day (am)",H125="Half Day (pm)",H125="1.5 Hours",H125="1 Hour",H125="2 Hours")),(E125+2)*2.6," ")
Bookmarks