RebeccaTyler_Squires
New Member
- Joined
- Mar 4, 2014
- Messages
- 7
Hello all,
I'm looking to create a formula which looks up the minimum and maximum supplier credit terms, which also takes into account whether the terms are net (just the days listed) or end of month (plus 30 days)? See below for required detail:
Layout of relevant column headers:
G2: Payment days - number (data validation)
H2: Payment terms (Net, End of month, etc) (text)
How can I make the MIN (or similar) formula look up the smallest value of payment days (G2) which are also "Net" (H2)?
and
How can I make the MAX (or similar) formula look up the largest value of payment days (G2) which are also set up as "End of month" (G2) and then add 30 days to take into account the longest possible end to a month?
I'm usually pretty good with forumlas, but my brain is making me do this in about six steps today!
Thanks in advance.
I'm looking to create a formula which looks up the minimum and maximum supplier credit terms, which also takes into account whether the terms are net (just the days listed) or end of month (plus 30 days)? See below for required detail:
Layout of relevant column headers:
G2: Payment days - number (data validation)
H2: Payment terms (Net, End of month, etc) (text)
How can I make the MIN (or similar) formula look up the smallest value of payment days (G2) which are also "Net" (H2)?
and
How can I make the MAX (or similar) formula look up the largest value of payment days (G2) which are also set up as "End of month" (G2) and then add 30 days to take into account the longest possible end to a month?
I'm usually pretty good with forumlas, but my brain is making me do this in about six steps today!
Thanks in advance.
