| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple cell fuction results in fraction format
Try:
=IF(T50,TRIM(TEXT(V5/25.4,"# ??/??"))&"""","") =IF(T50,TRIM(TEXT(AW5,"# ??/??"))&""" X "&TRIM(TEXT(AX5," # ??/??"))& """","") HTH "cfused128" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple cell fuction results in fraction format
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 -- Brevity is the soul of wit. "cfused128" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple cell fuction results in fraction format
Thanks, your response works great and will be a time saver over the long hand
method. "Toppers" wrote: Try: =IF(T50,TRIM(TEXT(V5/25.4,"# ??/??"))&"""","") =IF(T50,TRIM(TEXT(AW5,"# ??/??"))&""" X "&TRIM(TEXT(AX5," # ??/??"))& """","") HTH "cfused128" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Format Cell | Excel Discussion (Misc queries) | |||
| Need additoinal symbols for fractions | Excel Discussion (Misc queries) | |||
| Searching for multiple results in one cell | Excel Worksheet Functions | |||
| How do you format a cell for % varience for multiple answers | Excel Worksheet Functions | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Linear Mode
