ExcelBanter - Rounding Help needed?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rounding Help needed? (https://www.excelbanter.com/excel-worksheet-functions/168430-rounding-help-needed.html)

gb_S49

Rounding Help needed?

I am using the following formulaeto report the cost value in cell E2 which is
a calculated value.
="Average Cost ="&" "&(E2)
I get in return
Average Cost = 27.95959
What I Want is Average Cost = 28
What do i need to do just to round the value - the fromat of the cell does
not make any difference?
:-(

Gary''s Student

Rounding Help needed?

="Average Cost ="&" " & ROUND(E2,0)
--
Gary''s Student - gsnu200759

"gb_S49" wrote:

I am using the following formulaeto report the cost value in cell E2 which is
a calculated value.
="Average Cost ="&" "&(E2)
I get in return
Average Cost = 27.95959
What I Want is Average Cost = 28
What do i need to do just to round the value - the fromat of the cell does
not make any difference?
:-(

gb_S49

Rounding Help needed?

Brilliant
Thank You

"Gary''s Student" wrote:

="Average Cost ="&" " & ROUND(E2,0)
--
Gary''s Student - gsnu200759

"gb_S49" wrote:

I am using the following formulaeto report the cost value in cell E2 which is
a calculated value.
="Average Cost ="&" "&(E2)
I get in return
Average Cost = 27.95959
What I Want is Average Cost = 28
What do i need to do just to round the value - the fromat of the cell does
not make any difference?
:-(

All times are GMT +1. The time now is 08:04 AM.