Hi,
I have got to this stage with a formula but cannot understand why it isn't working:
=IF(OR(A2=1,A2=2),(MIN(B2:B6)+50),(MAX(B2:B6)+50))
If A2 equals 1, I want it to add 50 on to the smallest (earliest) date in C2:C5.
BUT
If A2 equals 2, I want it to add 50 on to the largest (latest) date
The formula just adds 50 on the smallest (earliest) date, whether A2 equals 1 or 2.
What am I doing wrong?
Any help or advice would be much appreciated.
Toby
Last edited by Tnashnhsp1; 11-27-2013 at 11:35 AM.
Try
Formula:
Please Login or Register to view this content.
This formula returns "" if A2 is neither 1 nor 2. Change the last "" in the formula if you want this value to be something else.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
your formula says if a is 2 or a is 1, use the minimum date.
OR(A1=1,A2=2) equals true if either condition is met, presumably you want:
=IF(A2=1,(MIN(B2:B6)+50),IF(A2=2,(MAX(B2:B6)+50),""))
Your OR statement evaluates to TRUE if A2 is either 1 or 2. Hence it will always be true, hence it will always be MIN + 50
Try:
=IF(A2=1,MIN(B2:B6)+50,IF(A2=2,MAX(B2:B6)+50))
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Hopefully 1 of the suggestions above worked for you
However, Administrative Note:
- We would love to help you with your query, but first, before we can proceed…
- Please see Forum Rule #1 about proper thread title
- Please PM me when complete (Also, include a link to your thread - copy from the adress bar) and this post will be removed which will reset the replies to zero…
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
many thanks for your help, these formulas worked, especially thanks for explaining why I was wrong, I have much to learn yet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks