I don't see any rounding function in your original formula. If you changed it to =Round(.75*F2,0)&" Units Reg Insulin", it should come out with the same result.
I don't see any rounding function in your original formula. If you changed it to =Round(.75*F2,0)&" Units Reg Insulin", it should come out with the same result.
What darkyam suggests is preferable, IMO; the result is a number and can be used in further calculations. The units are just formatting.
With khamilton's suggestion (which is appropriate for some circumstances), the result is text. The number will appear in full precision unless you format (or round) it:
=text(A1, "0") & " your text"
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks