Hello
I have a whole number with no decimal place entered into F3 but I need the formula answer to format the number out to one decimal place even though I am combining it with text.
If F3= 790, I am looking for answer = 438.9 uL. Is this possible?
I have a whole number with no decimal place entered into F3 but I need the formula answer to format the number out to one decimal place even though I am combining it with text.
If F3= 790, I am looking for answer = 438.9 uL. Is this possible?
Excel Formula:
=IF(F3="","",CONCAT(F3*10/18," uL"))