G
George
Excel 2007
Looking for a formula for the following;
If cell A3 = 10 and cell B3 = 12, then cells S3, S10 and S14 should display
the number .85
If cell A3 = 12 and cell B3 = 16, then cells S4, S11 and S15 should display
the number 1.20
If cell A3 = 18 and cell B3 = 18, then cells S5, S12 and S16 should display
the number 1.50
....
Looking for a formula for the following;
If cell A3 = 10 and cell B3 = 12, then cells S3, S10 and S14 should display
the number .85
If cell A3 = 12 and cell B3 = 16, then cells S4, S11 and S15 should display
the number 1.20
If cell A3 = 18 and cell B3 = 18, then cells S5, S12 and S16 should display
the number 1.50
....