View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cfused128 cfused128 is offline
external usenet poster
 
Posts: 2
Default 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