• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to calculate a 15 year age difference between 3 or more people

K

Korliss Green

New Member
I wanted to know if there's a way to calculate a 15 year age differnce between the patients in the same room. In other words if I have three or more people in a room, then I need to fiqure out if there's more than a 15 year age differences. Please see attachment.

Thanks!!!
 

Attachments

F2: ="Max age difference = "&TEXT(INT(MAX(E2:E4)-MIN(E2:E4))/365.25,"0.0")& " Years"

If you simply want to know is there a greater than 15 Years age gap:
F2: =INT(MAX(E2:E4)-MIN(E2:E4))/365.25>15

Copy to F6, F10, F14 etc
 
Korliss Green said:
I wanted to know if there's a way to calculate a 15 year age differnce between the patients in the same room. In other words if I have three or more people in a room, then I need to fiqure out if there's more than a 15 year age differences. Please see attachment.

Thanks!!!
Click to expand...
json said:
same question...do you just want a yes no for each room? or a yes no for each person?

??
Click to expand...
First, than you for your response. Yes ,for each person would work best.
 
Korliss Green said:
First, than you for your response. Yes ,for each person would work best.
Click to expand...

but isnt a single yes/no useless? i mean lets say we have 3 people in a room. A B & C. A could be 15 yrs apart from B AND/OR C, B could be 15yrs apart from A AND OR C, and the same goes for person C.... would returning just 1 yes for Person C be enough/all you'd need? just that they are 15 years apart from someone else in the room, but not need to know whom?

just want to understand how it is being used......... (wish i saved my file from yesterday!)
 
Hui said:
F2: ="Max age difference = "&TEXT(INT(MAX(E2:E4)-MIN(E2:E4))/365.25,"0.0")& " Years"

If you simply want to know is there a greater than 15 Years age gap:
F2: =INT(MAX(E2:E4)-MIN(E2:E4))/365.25>15

Copy to F6, F10, F14 etc
Click to expand...
Hui, thanks for the formula, but it did not work for me.
 
json said:
but isnt a single yes/no useless? i mean lets say we have 3 people in a room. A B & C. A could be 15 yrs apart from B AND/OR C, B could be 15yrs apart from A AND OR C, and the same goes for person C.... would returning just 1 yes for Person C be enough/all you'd need? just that they are 15 years apart from someone else in the room, but not need to know whom?

just want to understand how it is being used......... (wish i saved my file from yesterday!)
Click to expand...
Yes, you are right! One yes or no would be enough!!! I appreciate your help.
 
You must log in or register to reply here.
Back
Top