Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hey
Im a final yr degree student . Loading (KN) 4kN 5kN 6kN 7kN Depth 100 2.5 2.3 2.4 2.5 150 2.9 2.5 2.7 2.8 200 2.6 2.7 2.4 2.2 250 2.7 2.7 2.7 2.7 The Left Hand Column contains the Depth of the Slab Required in mm The Top Row is The MAX Loading Applied in Kn The internal values are the distance the slab must span in metres My problem is that if I were to pick a load value of 6kn over a slab distance of 2.6m then i would like it to return the corresponding slab depth; in this case 150mm or 250mm is sufficent. Similarily if i was to choose a load of 7Kn and a slab span of 2.8m then it would return a depth value of 150mm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
I want to use the MATCH function with the AVERAGE function but I . | Excel Worksheet Functions | |||
Lookup Function - Specific Values | Excel Worksheet Functions | |||
Match Function arguments | Excel Worksheet Functions | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions |