IF function

New Contributor

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?

2 Replies

@linroji 

=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.

hi!! that's exactly what I needed, thanks a lot!