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


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