multiple cell fuction results in fraction format

C

cfused128

Can anyone help me with this problem? Is excel capable of performing this
task?
I have set the cell format to: # ??/??
AW5 AX5 AZ5
HEIGHT WIDTH W x H
61 1/2 4 3/4" 4 3/4" X 61.5"

AW5=IF(T5>0,V5/25.4,"")

AZ5=IF(T5>0,AX5&" X "&AW5&"""","")

I would like thecell (AZ5) end result as follows:
4 3/4" x 61 1/2"
Any help in the right direction would be greatly appreciated
 
T

Toppers

Try:

=IF(T5>0,TRIM(TEXT(V5/25.4,"# ??/??"))&"""","")

=IF(T5>0,TRIM(TEXT(AW5,"# ??/??"))&""" X "&TRIM(TEXT(AX5," # ??/??"))&
"""","")

HTH
 
D

Dave F

Yeah Excel is capable of the task. You just have to tell Excel how the
number should be formatted, within the formula.

Toppers' suggestion seems to be the way to do it.

Dave
 
C

cfused128

Thanks, your response works great and will be a time saver over the long hand
method.
 
Top