Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Formula for converting decimals to fractions

Solved
Jump to Solution
193 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I thought I was being clever but my formula did not work. Cells are blank. Why?

SWITCH(
  {Decimal},
  "0.75",
  "3/4",

  "0.50",
  "1/2"
)
1 Solution

Accepted Solutions
John_B2
6 - Interface Innovator
6 - Interface Innovator

If your field {Decimal} is a numeric rather than text field you should put 0.75 not "0.75" etc.

See Solution in Thread

3 Replies 3
John_B2
6 - Interface Innovator
6 - Interface Innovator

If your field {Decimal} is a numeric rather than text field you should put 0.75 not "0.75" etc.

Is your {Decimal} field type a number, formula, or text? In addition to following John’s advice about using a number in your switch, if your field is a formula, the formula results might not be exact values to match your switch. You might need to do some rounding in your formula or you might want to consider nested IFs. 

My {Decimal} field is indeed a number and, therefore, removing the quotation marks worked like a charm. Thanks, John_B2, for the solution. And thanks, kuovonne, for sharing suggestions in case the field wasn't a number. I really appreciate the help! 🙂