Try

=IF(BE777BF777,BL777-BB777,IF(BF777BE777,BC777-BK777,BI777))

Mike

"Tracey" wrote:

I have the following but it just brings back "BI777"

=IF(AND(BE777="true",BF777="false"),BL777-BB777,IF(AND(BE777="false",BF777="true"), BC777-BK777,BI777))



"Mike H" wrote:

Tracey,

If the only possibilities for A1 and b1 are TRUE/False then you could do this

=IF(A1<B1,"Do My Vlookup","Do Something else")
or
=IF(A1+B1=1,"Do My Vlookup","Do Something else")

Mike

"Tracey" wrote:

Hi

I'm needing to calculate the following

If A1=True AND B1=False then calculate duration from start date and time to
SLA end time (this is on sheet 2 - vlookup??)

would the same format of the statement work if A2=False and B2=true ?

many thanks for your help
Tracey