Return Number

  • Thread starter Thread starter George
  • Start date Start date
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
....
 
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
 
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.
 
Back
Top