Return Number
 

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

Return Number
 

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

Return Number
 

A formula cannot push values into another cell. In each of the cells where
you want a result, put the relevant formula.
I assume that you want a blank result if your conditions aren't met, so in
S3, S10 and S14 your formula would be =IF(AND(A3=10,B3=12),0.85,"")
Similarly in the other cells.
--
David Biddulph

"George" wrote in message
...
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
...