excelformulacalc
How to use fraction string in Excel/Calc/Sheets as formula
I am having trouble to create a proper solution for following problem.
It shall be possible to enter fractions in a excel cell, which shall be used for further calculations.
Very simplified, it should like this:
A B C
Value Fraction Result
1 120 1/3 =A1 * B1
I dont want to enter =1/3, because the cell will then display 0,33333. On one hand, it looks ugly, on the other, most people will be able to identify 0,333 = 1/3 but 7/5 or 17/4 will be difficult.
I am looking for a solution that works in Excel, OO/LO Calc and Google Sheets.
VBA is out of scope, unfortunately.
Solution
Choose cells you want to enter fractions in. Right-click -> Format cells... -> Custom -> input #/#
B1:B3 formatted with rule above. Result:
- Excel number format to only show decimals when necessary
- Private Sub for hiding worksheets based on cell value "View" / "Hidden"
- Power Query Filtered Rows based on value
- EDI translator to excel
- If formula (the sum is less than 30 then roundup tp 30)
- Unable to use a dynamic named range as a data series - what am I doing wrong?
- How to get the path of current worksheet in VBA?
- vba + copy sheet from one wb to another wb
- Is it still not possible to open Excel from a Word Add-In?
- Excel-365 functions don't work as expected
- Sum values based on three criteria and transpose result from tabular to visual layout
- How to use fraction string in Excel/Calc/Sheets as formula
- VBA Code Save in Local and Upload to Sharepoint
- List Sheet Names Without Macro or Excel 4 Functions
- Delete a specific value from one column and Rename another Value in Excel using office script
- Highlight cell in first column if row contains a partial text match
- Excel - Aggregate dynamically values in a Table using array formulas (MAP, BYROW, CHOOSECOLS, TEXTJOIN, LAMBDA, FILTER, HSTACK) in a single Cell
- How to convert a FILETIME to an excel date
- VBA CountIf() loop / Countifs() loop
- How to construct Dataframe from a Excel (xls,xlsx) file in Scala Spark?
- excel filter data and remove units of measurement
- How to reference the current User\Desktop location in VBA
- Apache POI autoSizeColumn Resizes Incorrectly
- Copy cell values to another worksheet based on cell value
- Import Excel to Pandas Dataframe, but preserve order of Day/Month in dates?
- M Code(Power Query) to Remove Empty columns that runs fast
- Excel Count if first character is 0 in string
- How can I send Excel range including header, in table, and email to list?
- Dropdown Lists Emptying When Filling Data in Worksheet
- Excel: How to take a weighted average where blank values cause proportional weighting shifts