One idea is to use a vlookup ..

In Sheet1, in A1:B1 down,
you have your reference table:

6 6.6
7 7.2
8 7.8
etc

Then in any other sheet,
if the lookup value is in B3,
place this in B8: =IF(B3="","",VLOOKUP(B3,Sheet1!A:B,2,0)*B6)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"kitcatrn" wrote:
What formula do i use if
b3 = 6 then b8 equals b6 x 6.60
b3 = 7 then b8 equals b6 x 7.20
b3 = 8 then b8 eguals b6 x 7.80