Hello -
What would be a good formula to use to return specific values depending on the number in the adjacent cell?
I have a set of numbers in column B if I have 63 in B2, I would like a formula to return 61-90. If it's 28, then 1-30.
Value 1 Value 2
63
63
63
63
28
28
28
28
28
28
28
28
Thank you!
Last edited by yssong14; 10-22-2013 at 10:27 AM.
Can you explain your logic in what you want to return?
Pete
=if(B1=63,"61-90",if(B1=28,"1-30","")) might be what you are looking for.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Sorry. Could you explain what that means?Originally Posted by Pete_UK
Try
and copy it down column C
Please Login or Register to view this content.
Assuming your data is in A1 and downward, use this in B1 and fill down... How about something like this:-MooFormula:
Please Login or Register to view this content.
Formula edited... was inconsistent on exact numbers (30,60,90)
Last edited by Moo the Dog; 10-22-2013 at 10:09 AM.
What if there's a whole range of values? so pretty much any number in column B that is between 61-90, I want to show "61-90" in column C, and any number between 1-30 I would like to show "1-30", and any number between 31-60, I want to show "31-60".
i apologize for not being more specific.
Look at the Moo the Dog's response. I lost my crystal ball last week and didn't realize that there was more to your question than expressed.
Perhaps:
=LOOKUP(A2,INDEX(30*(ROW($1:$100)-1)+1,,))&" - "&LOOKUP(A2+30,INDEX(30*ROW($1:$100),,))
Regards
The formula I posted above should do this Yssong.
That's alright Alan... the last time I used my crystal ball was to hit a 7-10 split. The rest, as they say, is history. =)
- Moo
Another crystal ball question !!
Hello, Moo, I've not seen you posting for a while.
Pete
This worked! Thank you all so much!Try
and copy it down column CPlease Login or Register to view this content.
Pete,
Hello to you as well! Yes, my time committed to helping out around here has been quite limited for much of the year - job demands, family, etc.
It seems you guys have been handling things pretty well without me here, but I am glad to help out when I can.
- Moo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks