Remember Me?

#### Menu

#1
March 25th 19, 11:17 PM
 Junior Member First recorded activity by ExcelBanter: Apr 2013 Posts: 19
Pass Fail on multiple variables

I have a question, I want to look a 2 different numbers and determine if a test is pass or fail.

You are given a "curve #" Excel has a list of these curves.
you give excel "unit Weight and Moisture" In the "curves table it specify a minimum compaction based on the "curve" and moisture array say Optimum +3% or Optimum +-3% etc.

I posted the sheets here.

Index of /Excel

on Line 15 you can see where i was experimenting.
I did make the table on page Curves a named range. Curves

I need columns h & m to meet the specs on page "curves:" column
In other words line 9 column H needs to be 13 to 17% and column n needs to be greater than 114.2 for a PASS else Fail.

TIA for any Help

Milo

#2
March 27th 19, 06:30 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Oct 2016 Posts: 18
Pass Fail on multiple variables

On Monday, 25 March 2019 22:49:04 UTC, Milo Bloom wrote:
I have a question, I want to look a 2 different numbers and determine
if a test is pass or fail.

You are given a "curve #" Excel has a list of these curves.
you give excel "unit Weight and Moisture" In the "curves table it
specify a minimum compaction based on the "curve" and moisture array
say Optimum +3% or Optimum +-3% etc.

I posted the sheets here.

'Index of /Excel' (http://pourtney.com/Excel/)

on Line 15 you can see where i was experimenting.
I did make the table on page Curves a named range. Curves

I need columns h & m to meet the specs on page "curves:" column
In other words line 9 column H needs to be 13 to 17% and column n needs
to be greater than 114.2 for a PASS else Fail.

TIA for any Help

Milo

--
Milo Bloom

Hi Milo
Why not create another named range called Curves2 just containing the 4 values you want to use in your Lookup for each curve.
I created a named range called CurvesRow as =Curves!\$B\$4:\$B\$10
I then placed the 4 parameters in cells M4:P10, and named this range as Curves2.

Then your formula becomes
=IF(A15="","",LOOKUP(N15,INDEX(Curves2,MATCH(G15,C urvesRow,0),),{"Fail","Pass"}))
#3
March 27th 19, 06:14 PM
 Junior Member First recorded activity by ExcelBanter: Apr 2013 Posts: 19

Quote:
 Originally Posted by Milo Bloom I have a question, I want to look a 2 different numbers and determine if a test is pass or fail. You are given a "curve #" Excel has a list of these curves. you give excel "unit Weight and Moisture" In the "curves table it specify a minimum compaction based on the "curve" and moisture array say Optimum +3% or Optimum +-3% etc. I posted the sheets here. Index of /Excel on Line 15 you can see where i was experimenting. I did make the table on page Curves a named range. Curves I need columns h & m to meet the specs on page "curves:" column In other words line 9 column H needs to be 13 to 17% and column n needs to be greater than 114.2 for a PASS else Fail. TIA for any Help Milo
Thanks for the help, I seemly tried to follow the instructions but get a #N/A
I tried to step through it and seems to be ok until the final step.
I posted the new file as version 4.

Thanks Again :-)

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Nadine Excel Worksheet Functions 9 August 6th 13 10:20 AM mrsatroy Excel Discussion (Misc queries) 2 April 19th 10 05:05 PM jhumphreys New Users to Excel 6 July 7th 09 01:26 AM Robert Charts and Charting in Excel 3 April 12th 09 11:41 PM Tricia New Users to Excel 3 January 20th 05 04:45 PM

All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright ©2004-2020 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"

Copyright © 2017