Formula to Use Named Ranges

[usedcarTA]

I am trying to help my son with some homework that is requiring us to create some formulas using named ranges to determine an employees time since starting. The statement in the project guide says "Create a formula using the name ranges that adds the total number of years (to two decimal places) for each teacher and administrator based on their hire date." If I use the following formula I get the correct answer:

=IF(Admin_Salaries,ROUND(DAYS(TODAY(),C2)/365.25,2), "")& " Years"

This only gives me the answer for the named range of Admin Salaries, I need the formula to also give the answer if the named range is Teacher_Salaries. I tried this but I cannot get it to work:

=IF(OR(Admin_Salaries,Teacher_Salaries), ROUND(DAYS(TODAY(),C2)/365.25,2), ""))& " Years"

I've attached the project guide.

[Keebellah]

Hi, welcome to the forum
You should use join for both named ranges, the OR function has no use here and ... I wonder why they want the named ranges since it looks that they're all in the same column
I've downloaded the file and read what they're actually asking, no promises though

[usedcarTA]

Thanks for taking a look. I figured I could use the OR so if the criteria matched either of the two named ranges it would calculate the years and place the answer in column F otherwise it wouldn't. Could I use VLOOKUP?

[Keebellah]

I think it's great that you're helping your son with some homework, but it's a lot to really ask here for help.
It's like cheating for an exam
I had to think about which formulas to use and how to use them and did come up with an idea and I think the solution.
I'll give you the three formulas I used, one for each column, E, F and one for G; this way its not all doen by one us and your son can complete it.
I'm sure others will have other ideas but I liked this one and ... I think the result is what you needed:

Formula for D 2

Please Login or Register  to view this content.

The iedea is that IFEEROR function when correct returns the result, when not it gives a 0 and that I dit for the three named ragnes in one formula, so one will alwyas return the correct answer and that is why I added the result, one will be a correct number and the other two will be 0

Formula for F 2

Please Login or Register  to view this content.

The same principle

Formula for G 2

Please Login or Register  to view this content.

And the final result(proof of result)

[usedcarTA]

I think it's great that you're helping your son with some homework, but it's a lot to really ask here for help.
It's like cheating for an exam
I had to think about which formulas to use and how to use them and did come up with an idea and I think the solution.
I'll give you the three formulas I used, one for each column, E, F and one for G; this way its not all doen by one us and your son can complete it.
I'm sure others will have other ideas but I liked this one and ... I think the result is what you needed:

Formula for D 2

Please Login or Register  to view this content.

The iedea is that IFEEROR function when correct returns the result, when not it gives a 0 and that I dit for the three named ragnes in one formula, so one will alwyas return the correct answer and that is why I added the result, one will be a correct number and the other two will be 0

Formula for F 2

Please Login or Register  to view this content.

The same principle

Formula for G 2

Please Login or Register  to view this content.

And the final result(proof of result)

Normally I would be inclined to agree with you but we worked on this for 4 days before emailing the teacher for some guidance over 2 weeks ago (He's doing virtual school). The silence is so deafening the crickets sound like a symphony. It's due next week.

Thanks for the help

[Keebellah]

You're welcome, glad to have helped anyway, we started from scratch too and needed all the help we could get.
Just one point when answering, just click replay and not reply with quote.
Hope your son gets an A

[Pasmith523]

Normally I would be inclined to agree with you but we worked on this for 4 days before emailing the teacher for some guidance over 2 weeks ago (He's doing virtual school). The silence is so deafening the crickets sound like a symphony. It's due next week.

Thanks for the help

I agree this online schooling stinks. They watch videos of a random guy. It shows you nothing. I am tring to help my son too ,but am failing miserably.

[protonLeah]

@Pasmith523,

Please don't quote whole posts -- it's just clutter.*If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.

Be sure that your comments actually contribute to the solution of the problem. This is not a political forum.