Using decimals in text?
Here's another question: Is it possible to change a line of text
depending on the value contained in a cell? For example, if I have a
decimal which is used as an exponent, can I concatenate that value with
a units string?
Example: value = 0.333, units = "kg" => "kg^0.333" (^ = font
Now change the value to 0.396 and the units label should read
use ="kg^"&A1 where A1 is the cell containing the decimal exponent. If you want to be able to change the units, use =B1&"^"&A1 where B1 is the cell containing the units.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1