# Use a formula based on a value in another cell

1. ## Use a formula based on a value in another cell

I'm relatively new to excel and have no experience with vba and macros, so any help is greatly appreciated!

I am working on a spreadsheet to track physical fitness tests.

I need the formula in the Pass/Fail column to auto-populate based on the age I have entered. Each formula is unique to each age group (20-29, 30-39, 40-49, 50-59) and what their qualifying times are.

Are there any macros that may be able to help me?

Thanks

2. ## Re: Use a formula based on a value in another cell

What are the criteria for each age range to Pass?

Edit: OOPS! I see them in your formulae.

3. ## Re: Use a formula based on a value in another cell

No VBA necessary. Used Vlookups. Look at the attached.

4. ## Re: Use a formula based on a value in another cell

That's perfect, thank you.

Couple more questions:

-Is there a way to fill the cells red/green in the formula based on passing/failing scores without using the conditional formatting?
-Can the gender be factored into this formula where females have different requirements?

Thanks!

5. ## Re: Use a formula based on a value in another cell

Coloring of the cells would require conditional formatting. Because requirements for gender will vary, I suspect that you will need to replicate the look up table I provided and use a similar formula, but on a separate worksheet. Vlookup can only support one value being looked up. However, having said that, I can think of a work around. Suppose you used the age for men as 120, 130, 140, 150 and for women you used 220, 230, 240, 250. Then you could do it in one lookup table and one spreadsheet of data.

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1