Fill amount from a cell if date is before end of month

Solved/Closed
hawkwms Posts 3 Registration date Tuesday February 4, 2014 Status Member Last seen February 6, 2014 - Feb 4, 2014 at 11:49 PM
hawkwms Posts 3 Registration date Tuesday February 4, 2014 Status Member Last seen February 6, 2014 - Feb 6, 2014 at 09:30 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Feb 5, 2014 at 11:12 PM
not clear
try this formula

=IF(B5<=D11,"outstanding"&" "& B4,"")
0
hawkwms Posts 3 Registration date Tuesday February 4, 2014 Status Member Last seen February 6, 2014
Feb 6, 2014 at 12:57 AM
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.
0
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Feb 6, 2014 at 04:32 AM
try this formula

=IF(B5<=D11,B4,"")
now format B4 as you like
0
hawkwms Posts 3 Registration date Tuesday February 4, 2014 Status Member Last seen February 6, 2014
Feb 6, 2014 at 09:30 AM
Excellent! Works perfectly! Thanks so much.
0