Hi Allison,

Am Fri, 27 May 2016 15:23:54 -0700 (PDT) schrieb Allison Mazurek:

Unfortunately, it did not. It keeps picking up the first value statment.

=IF(V2<$B$2,0,IF($Z$2TIME(11,30,0),'Current Day Balances'!$B$4-'Current Day Balances'!$D$4,'Current Day Balances'!$F$4-'Current Day Balances'!$D$4))

sorry, I forgot that in Z2 is a military time without colon. You have to
convert it in a regular time. Try:
=IF(V2<$B$2,0,IF(TIME(LEFT($Z$2,2),RIGHT($Z$2,2), 0)TIME(11,30,0),'Current Day Balances'!B4-'Current Day Balances'!D4,'Current Day Balances'!F4-'Current Day Balances'!D4))


Regards
Claus B.
--
Windows10
Office 2016