calculating fees from other cells

S

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
 
G

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.
 
Top