Complex If Statement

**mewingkitty** · 12-08-2008, 10:57 AM

Only thing left is if there's a payment planned date which is sooner than the due date, it lists them both. Not sure how that affects your end of things.

=IF($B15="X","",IF(AND($R15>0,$R15<=Y$8,$R15>X$8),$S15,IF(AND($P15>0,$P15<=Y$8,$P15>X$8),$Q15,IF(AND($N15>0,$N15<=Y$8,$N15>X$8),$O15,IF(AND($L15>0,$L15<=Y$8,$L15>X$8),$M15,IF(AND($I15>0,$I15<=Y$8,$I15>X$8),$E15,(IF(AND($H15<=Y$8,$H15>X$8),$E15,IF(AND(SUM($R15,$P15,$N15,$L15)=0,$I15>0,$I15<X$8,$I15>=Y$8),$E15,IF(AND($I15=0,$H15>0,$H15<X$8,$H15>=Y$8),$E15,IF(AND($H15=0,$I15=0,$C15>0,$C15>X$8,$C15<=Y$8),$E15,"")))))))))))

See attached.

**robert_shindorf** · 12-10-2008, 12:08 PM

ok... sorry again... it was my birthday, so i was taking an excel vacation.

so, if a planned payment date is before the due date it shows both.... hmmm... i hadn't thought of this before... companies don't usually pay in advance... but, if it happens, the planned date should over ride the due date... since it was a manually entered number, and not a function of the invoice date plus the terms.

**mewingkitty** · 12-10-2008, 01:53 PM

Got that resolved.

Last issue conceivable ( hate to say that, cause now there'll be others )

Is this possible -

No bill date,
no plan to pay date,
yet...
a payment it posted with a date.

I really think that if they post it, a planned to pay date should be posted along with it, but I'm not the one who has to use the thing, so lemme know!

I believe we've now covered - planned date before bill date, no planned date, no due date.

Complex If Statement

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

mmmMMM!?

One more time!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions