Thread: Return Number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George George is offline
external usenet poster
 
Posts: 347
Default 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
....