Hi All, I have a basic knowledge of Excel formulas.

Now I need a formula using 3 columns. eg: A1, B1, C1.

OK my column A1 needs to be able have input such as 400, which value needs to be $5.00, 600, value $8.00, etc. There are 6 numbers with different values.

Now my column B1 has a similar style, but with only 2 values R1=$2, R2=$4.



column C1 needs to be able to calculate the sum of A1 + B1 = C1
eg: 400 + R1 = $7.00 OR 400 + R2 = $9.00.

I hope this is understandable. Help would be greatly appreciated.

Thanks websiteaog