*.xlsx Cell Formula Question.

[Pinaceous]

Hi All,

I'm using a Cell Formula, where I sum a number column and tag a unit of measure onto that generated sum:

=(SUM(R4:R29))/(-8)&" days used"

When I use this formula it provides the cell value to the ten-thousands place. For example, 8.0625:

How would I provide my number result to produce 8.1 or 8.06 ect. in the formula cell?

Please let me know!

Thank you,
pinaceous

 

[rollis13]

If I correctly understood your request, maybe:
=TRUNC(SUM(R4:R29)/(-8),2)&" days used"

 

[Pinaceous]

Awesome!

Thanks rollis13!

 

[rollis13]

Thanks for the positive feedback, glad having been of some help.