Hi there,

i currently have the following formula that works
=IF(AND(Z2="Null",T2="Awaiting Assesment"),$AL$1-AE2,IF(Z2="Null","A",Z2-AE2))

What i am trying to do is add the following criteria to this also.

"Referred" & "Waiting Submission

so if T2 has either of these 3 criteria in the cell it, it will carry on the calculation.

i have tried the following just with the "Referred" to see if i could get it to work but it doesnt
=IF(AND(Z2="Null",T2="Awaiting Assesment"),$AL$1-AE2,IF(Z2="Null","A",Z2-AE2)IF(AND(Z2="Null",T2="Referred"),$AL$1-AE2,IF(Z2="Null","A",Z2-AE2)

How do i lay out the formula so it will look in T2 for all 3 of these criteria?

thanks