number value formatting issue

[londa_vba]

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?

=IF(F3="","",CONCAT(F3*10/18," uL"))

 

[londa_vba]

I split the formula into two parts and was able to get the deserved answer = 438.9 uL

=IF(F3="","",(F3*10/18," uL"))

and then

=TEXT(C4,"0.0"&" uL")

Is this the best way?

 

[Fluff]

How about

=IF(F3="","",TEXT(F3*10/18,"0.0 uL"))

 

[londa_vba]

How about

=IF(F3="","",TEXT(F3*10/18,"0.0 uL"))

works beautifully thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Scott Huish]

You could also just divide by 1.8 and get the same answer.

=IF(F3="","",TEXT(F3/1.8,"0.0 uL"))

 

[felixstraube]

If you just want to show that result in another cell then you can achieve this just by formatting the cell like so: