Using the value from one cell in forula in another cell

[PJMa]

No doubt this is very elementary, but I can't find the answer
On the attached spreadsheet sample, I want to put a formula in cell K4 that takes the value in cell J4 and simply multiplies it by 4.
The formula in cell J4 is "=ROUND(I4, 1)"
However, when I try to do so, it instead seems to pick up the unrounded number (i.e. the value from cell I4), and therefore gives the answer in cell K4 of 5.2 rather than the 4 I am looking for.
Please can someone put me out of my misery and explain (in fairly simple terms) what I'm doing wrong.
Thank you

 

[Joe4]

Welcome to the Board!

Excel uses the actual values in the underlying cell, not the displayed/formatted value.
The issue is the the value in cell I4 is actually 1.3, not 1. You have just formatted column I to show no decimals.

If you want column J to be 1, and not 1.3, then you need to round off to 0 decimal paces, i.e.

=ROUND(I4,0)

The formula you had before round off to one decimal place.

 

[PJMa]

Thank you so much. It was indeed a very basic error!!

 

[Joe4]

You are welcome.
Glad I was able to help!