Multiple IF functions, different ranges

[Scott Kieta]

Here is the scenario

Calculating the difference in times

=IF(G17="",H17-E17,(H17-E17)-(G17-F17))

I want to be able to add a 2nd function that would cancel this request if
J17= "Reject"

Can this be done utilizing an OR function or a 2nd IF function?

 

[Tyro]

I'm not exactly certain what you mean by "cancel this request". If you mean
to return nothing when J17="Reject" then:
=IF(J17="Reject","",IF(G17="",H17-E17,(H17-E17)-(G17-F17)))

Tyro

 

[Scott Kieta]

That is exactly what i meant, this works for me.

Thanks