Dec 07 2021 01:07 PM
Hi everyone,
I have been trying for a while to set up a formula using IF to evaluate 2 conditions with the objective of showing on column F the time spent from column J based on conditions from Columns A and D. (please see the excel file attached)
I tried the formula on Cell F2 but is not working, its only showing the result of the condition evaluation for the first criteria
can anyone help me?
Dec 07 2021 01:18 PM
=IF(AND(A2="Call Maintenance",D2="Linked In"),$J$2,IF(AND(A2="Call Maintenance",D2="Linked Out"),$J$3,IF(AND(A2="Call Maintenance",D2="Reject Call"),$J$4)))
Is this what you are looking for?
In order to check for further criteria of call type and resolution you can adapt above IF formula or apply a vlookup / choose function.