You need the following in cells S3, S10 and S14
=IF(AND(A3=10,B3=12),0.85,"")
or the above formula in S3 and this in S10 and S14
=S3


and similar formulas in other cells...

Is there any pattern? If yes, then you can have it in one formula and simply
copy it

"George" wrote:

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
...