Derive one answer from 9 criteria and other variables
This is a follow on issue. In the attached Rows 4,9,14 contains titles for a set of calcs - upwind, downwind cliffs and escarpments, and downwind hills and ridges. Cells L5-L7 are the variables ( Note:- I have disconnected the linked data and simply pasted some values in. Alternative values are shown in adjoining cells.
Cell L9 is the unique value i need to return.
Where the φ value <= 0.05 this is the same for the 3 titles - value 1.
In essence for upwind, there are 3 variables, for downwind, there are 6 variables based on 2 titles. Cell L9 needs to use cells L5-L7 data need to check against the 9 variables
I started with an if(and(.... statement and soon got myself stitched up. Any steers appreciated. Would i be better indexing?
CO-issue.xlsx
Cell L9 is the unique value i need to return.
Where the φ value <= 0.05 this is the same for the 3 titles - value 1.
In essence for upwind, there are 3 variables, for downwind, there are 6 variables based on 2 titles. Cell L9 needs to use cells L5-L7 data need to check against the 9 variables
I started with an if(and(.... statement and soon got myself stitched up. Any steers appreciated. Would i be better indexing?
CO-issue.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER