Having a problem working with fractions, decimals, and dates. Trying to subtract two cells (formatted as decimals) from one cell formatted as a Pop-Up Menu using fractions. Numbers is defaulting to a date format when I need a decimal or fraction., H
Trying to subtract two cells formatted as numbers (decimals) from one cell formatted as a Pop-Up Menu using fractions. The only results that are correct are where I have selected a two digit numerator over a two digit denominator, such as 11/16. If I choose a single digit numerator over a two digit denominator (9/16) or both single digit (7/8), I get a blank cell. I get the same result when trying to Index and Match the same Pop-Up cell to it's decimal equivalent. Any help?