multiple cell fuction results in fraction format
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(T50,V5/25.4,"")
AZ5=IF(T50,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
|