I want to show water cost under OFFICE
if between 5-7 days after RR. If after 7 days, show under RECEIVED AFTER WELL CLOSED
, everything under 5 days shows up under FIELD
.
This is the current code being used that has not been updated to reflect the above criteria:
Entry: IIf(Date()>=[RR]+5,"OFFICE","FIELD")
Embed another if condition into the formula:
IIf(Date()>=[RR]+7,"RECEIVED AFTER WELL CLOSED",IIf(Data()>=[RR]+5,"OFFICE","FIELD"))