Previous Topic Next Topic

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 responses

Answer 1 / 3
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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
Answer 2 / 3
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 6, 2014 at 04:32 AM
try this formula

=IF(B5<=D11,B4,"")
now format B4 as you like
0
Answer 3 / 3
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

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Formula to Find&replace blank cells in excel
onetuff_z -
tstobb -

11 responses
Excel - IF function with multiple words
Nick -
user -

14 responses