Multiple IF functions, different ranges

S

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?
 
T

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
 
Top