What if i am twelve? The formula is a line equation, so although it gets exponentially bigger, it'll also get to a point where it equals nothing, and then starts going back up in reverse ; Hence why the formula doesn't work for you. Besides that, you shouldn't be dating at 12 :P. The reason why the math doesn't work if you are twelve is because you shouldn't date anyone at your age, young lady. Now go to your room.
Im confused. Not by the equatio; that works fine.
What I'm confused about is the amount of young teens being told they shouldn't be dating? Does dating mean something different where you live?
Here in the UK it means 'to go out with' or 'to court' etc. Are you talking about sexual dating, serious relationship dating, or general dating?
Starting from zero, a data analyst learns to date.
I assume sexual, of course, but I think that this should be more clearly stated. So at 40, the age range is 27 to My parents are No way in hell would I even even consider someone over My age is 16, and the youngest I can date is 15, the oldest is This actually kinda helped, because my boyfriend just turned 18, and I'm about to be You are commenting using your Twitter account.
Feb 11, Count age range formula I have a spreadsheet where a person's age is entered into a cell. I need to count how many are between , , , etc. Please tell me what formula I should use? Thanks. Last edited by cpope; at . Jun 11, Men's preferred minimum age for a partner is close to the formula's minimum. Both sexes' preferred maximum age is much younger than what the formula calculates. Women's preferred minimum acceptable age is older than what the formula calculates. The younger you are, the more accurate the calculations. You can read more here. A western rule-of-thumb is to take your age, divide it by two, and add seven to that (you 2 + 7). This finds the youngest age of a person you can have a romantic relationship with while keeping your relationship socially acceptable. However, this leaves you in the dark about who's too old for you. Well, let's look at this algebraically.
You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email.
How well do the formulas work? The younger you are, the more accurate the calculations.
Now, who will create a more accurate calculation? R Age Range Graph library shiny source "plot.
R" source "range. Like this: Like Loading PS- This is the first time I actually chose to do mathematical calculations for fun. By the way, I like that you cited - thefoodlumscatering.com.
I can spend hours on that website. Aww thanks, Pinky.
Formula to calculate dating age range
Should my age range group field should be a "formula" i'm thinking yes. What would be the formula syntex?
Dec 15, For example, if you start dating someone who is 20 when you are 26 years old, they are within the acceptable age range, according to the rule, but it is the very limit of your minimum age range. But when you are 30, and they are 24, your new age range is 22, and they are well above that thefoodlumscatering.com: Lachlan Brown.
But I can't seem to have it test for a value greater than or less than on the same line? Thanks in Advance! Michael S ahrcdocs gmail.
Dating Age Range Calculator
Kamal Khaj I fixed it. Applied the Case fomula.
JohnD December 26, It was no surprise to me that the link lead me to a woman's blog. Of course one may choose whatever age range they want on their profile, but if one is looking for a long term relationship, one can not ignore the fact that women in their 40s on average marry a man 4 years older, and conversely, men in their 40s on average marry a woman 4 years younger, so the ideal. Formula: Half Your Age Plus Seven Rule Younger= Age / + Older= (Age - ) * 2. This Dating Age Range Calculator just a fun tool to predict your dating age. Half your age plus seven rule states "never date anyone under half your age plus 7" also meaning that "no one under 14 years of . Oct 04, The range doesn't get wider as men get older, but it does get younger. Women's preferences, on the other hand, hold relatively constant across their lives, not going more than a few years below their own age (extra-credit if you can identify the "cougar zone" in this figure), but women remain keen on men up to 10 years older than.
It works and managed to compile size to the half of permited. Johan Yu So, now you have an age field as number field type, right? Age range group should be a formula field.
You can use IF to check for particular age, what is the age range. Anna Hendry Hi Michael, if you found these answers helpful, please come back and let us know by selecting 'Best Answer' underneath the comment.
This will mark your question as resolved and will help the community in the future if they have a similar inquiry. Kamal Khaj Good evening, Well, 7 years later I have been trying to use the formula listed above, but am getting the error, it is too big to excetute 12, characters.
Please assist me to find the solution to my puzzle. Apperenty, Salesforce is more compliated then simple VB language.
Jan 26, Here is a simple way of calculating your age range, and proven to be quite useful and accurate. your age / 2 + 7 = the youngest age you can date. (ex) your age=30 (not that I am, just that its a simple number to calculate mind you!) than 30 / 2 + 7 = 22 so if you're 30 you can't date anyone younger than Dec 02, I have an age range group (field) where I want to test the value of an AGE (field) and place the contact's age into the proper age range group field thefoodlumscatering.com range groups 63+ 12 or less Questions 1. Should my age range group field should be a "formula" (i'm thinking yes). 2. Women's preferred minimum partner age: Below are the data from Buunk et al.'s study on women's minimum age preferences; the rule's age calculations are represented by the solid line.