Hello all
Currently I am using the following formula to combine multiple cells to another sheet
=IFERROR((Repairs!B2&””&”/X/“&Repairs!C3),””)
this returns a result of FF/X/4 or FF/X/0.5 or
RU/X/10
the issue I am having is I need the result returned as follow containing 1 decimal place regardless of the amount of numbers before the decimal
FF/X/4.0
FF/X/0.5
RU/X/10.0
Can anyone please help with adjusting the formula. I have tried simple formatting without success and am unsure of how to do this
unfortunately due to circumstances I am limited to utilising formula only. Macro is not an option
thank you
Currently I am using the following formula to combine multiple cells to another sheet
=IFERROR((Repairs!B2&””&”/X/“&Repairs!C3),””)
this returns a result of FF/X/4 or FF/X/0.5 or
RU/X/10
the issue I am having is I need the result returned as follow containing 1 decimal place regardless of the amount of numbers before the decimal
FF/X/4.0
FF/X/0.5
RU/X/10.0
Can anyone please help with adjusting the formula. I have tried simple formatting without success and am unsure of how to do this
unfortunately due to circumstances I am limited to utilising formula only. Macro is not an option
thank you