Hi, I have this formula

=IF(TODAY()<AE$3;$E4-SUM($I4:AC4); ?????? )

AE$3 ->Is a date
$E4 ->is number witch is changing every days.

My problem is what do I put in the "??????" (condition_if_false) to apear the last calculated true value.
Maybe ther's a completely difererent way to do so...

Please help