Enter value in one cell to show answer in another cell

[ipbr21054]

Afternoon all,

I would like some advice for the following if i may.
The calculation is the value entered into cell C6 + 5.4% + 20p
The answer is to be then shown in cell C7

Many thanks

 

[JLGWhiz]

Here is one method
assuming the p represents pencce, in cell C7 put

=(C6*0.054)+0.2&"p"

You might need to set your number format for the Column C to only allow 2 decimal places. You can do that by selecting column C and then 'Format Cells'.

 

[ipbr21054]

Thanks

 

[JLGWhiz]

Thanks

You're welcome,
regards, JLG