Fill amount from a cell if date is before end of month [Solved/Closed]

Report
Posts
3
Registration date
Tuesday February 4, 2014
Status
Member
Last seen
February 6, 2014
-
Posts
3
Registration date
Tuesday February 4, 2014
Status
Member
Last seen
February 6, 2014
-
Can someone please help. I'm trying to track outstanding bills due by the end of month as in the following example:

If date in cell B5 (due date) is before cell D11 (end of month date) then fill B12 (outstanding unpaid bill amount) with contents of B4 (monthly bill amount due)

Thanks in advance.
Hawk ^V^

3 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
not clear
try this formula

=IF(B5<=D11,"outstanding"&" "& B4,"")
Posts
3
Registration date
Tuesday February 4, 2014
Status
Member
Last seen
February 6, 2014

This works. Except I deleted the "Outstanding" and am having trouble formatting the cells to currency. It just lists the raw number without currency or the two decimal places. Thanks a ton.
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
try this formula

=IF(B5<=D11,B4,"")
now format B4 as you like
Posts
3
Registration date
Tuesday February 4, 2014
Status
Member
Last seen
February 6, 2014

Excellent! Works perfectly! Thanks so much.