how to concatenate with rounded numbers (while keeping them rounded)?
回答 (2)
2014-11-19 4:47 pm
✔ 最佳答案
in excel, there are functions for round, roundup,rounddown
2014-11-19 3:58 pm
edit: I figured out one way
=concatonate(round(a8,1), ' / ', round(b8,1))
=concatonate(round(a8,1), ' / ', round(b8,1))
收錄日期: 2021-05-01 15:13:27
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20141119074956AAFy8H5