Monster Formula Help on Late Fees

**mcarr5** · 03-05-2010, 09:41 PM

Hi,

DonkeOte, previously helped me with this Monster formula and I'm asking for a second look.

Simply stated I take an aged analysis of accounts receivable that repeats the interval between accounts. The formula recognizes that sequence and totals the calculate late fees. It also subtotals any previously charged late fee ((LF-) and then adds it all up to expose the late fee to be charged. I'm getting 'False' and "#value' as shown on the attached. Is it possible to overcome these???
Mucho Thanks
Mike

**DonkeyOte** · 03-06-2010, 05:06 AM

If we refer back to the original thread:

http://www.excelforum.com/excel-gene...eceivable.html

we will note that you altered some references which are in turn generating circular references - not the cause of #VALUE! per se but should definitely be avoided.

Working from the last file of the last thread and comparing to current I would suggest you set your present file up such that:

Please Login or Register  to view this content.

The above would generate final results in H of:

Please Login or Register  to view this content.

**mcarr5** · 03-06-2010, 09:13 AM

DonkeyOte:

Thank you so much this worked.

Monster Formula Help on Late Fees

LinkBack

Thread Tools

Rate This Thread

Display

Monster Formula Help on Late Fees

Re: Monster Formula Help on Late Fees

Re: Monster Formula Help on Late Fees

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions