hi guys
i have the following in cell S11
T6 is a whole number always lets say 3 in this example![]()
=T6&" Units @ "&U4&" x "&U5
cells u4 or u5 may not be whole numbers
for example if cell U4 is 0.90166666667 and U5 is 1.500
then i get the answer
3 units @ 0.90166666667 x 1.500
so what i really need it to read is
3 units @ 0.901 x 1.500
thanks in advance
Bookmarks