calculating fees from other cells

[Skills]

Hi

I have two columns, finalvalue and fees, I would like the cells in fee
to look at the finalvalue cells, take the number and take 3.4% + £0.2
from it. Can anyone help me with this?

Thank

 

[Govind]

Hi,

Lets say the column A has finalvalue and col B has fees then in col B
enter the formula

= (A1*3.4%)+0.20

and format it in pounds.

Regards

Govind.