| 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 |
| 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) | |||
Threaded Mode
