Hi all, and thanks in advance
I want some formulas to do this:
If the number in column d is less than 1 Million, and will stay under 1 million if column c is added, then column c number is added to d, otherwise it is added to column e figure.
This makes the figures in columns d and e go up of course over time, but after 30 days from enter, it gets paid and will be removed from the column it entered into
It this possible to solve?
kind regards
Last edited by ELISABETHR; 03-16-2022 at 04:50 AM.
Administrative Note:
Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
The way you want this to work is VERY confusing. It appears to be looking at prospective (future) income/expenditure.... as all the col A dats are int he future.
Since you didn't SHOW us what you wanted, by way of expected answers... a guess:
=IF($A2+30< TODAY(),"",IF($C2="","",MIN(10^8,SUM($C$2:$C2))))
and
=IF($A2+30< TODAY(),"",IF($C2="","",MAX(0,SUM($C$2:$C2)-10^8)))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thanks heaps
Sorry to be so unclear.
The numbers in column C are supply items entering the supply chain.
If the total value in column D is within 100Mill including the latest entry, then this entry gets added to column c, otherwise it will be entered in full in column E.
Also, these items of supply are bought on 30 days, so after 30 days they will be paid, so will be removed from the same column they were added to.
Does that make more sense?
I am very grateful as this is far past my excel knowledge.
Thanks again!!
1. You still haven't done as requested in Post #2. Please do so.
2. You haven't supplied expected answers as suggested in Post 3.
3. Your sample data is not diverse enough - none of it addresses the scenario of being less than 1,000,000.
Anyway, here's a guess (starting in Row 2 and copy down):
=IF(SUM(C2:D2) < 1000000,SUM(C2:D2),SUM(D2:E2))
My aplogies to all.
I have added a book (7) attachment where I have added expected answers and hopefully made clear what I wanted.
I have also written a text box
Kidn thanks
Elisabeth
Which version of Excel are you using?
Microsoft 365 MSO (Version 2201 Build 16.0)
Please update your profile to reflect this.Microsoft 365 MSO (Version 2201 Build 16.0)
Where? What cell (Column) are the expected results?I have added expected answers
You mention about being under 1 Million a few times (in your Post#1 above, and in one of your text boxes in the file), but you also mention $100 Million. I'm assuming you meant $100 Million when you said $1 Million because I don't see any figures under $1 Million in your sample data.
Based on what you're saying, I'm still thinking this formula:
=IF(SUM(C2:D2) < 100000000,SUM(C2:D2),SUM(D2:E2))
But, I'm wondering if column B plays into the logic. You never mention it, but should it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks