Forum Discussion
Excel returning 1 or 0 instead of actual calculation results
So instead of providing the required answer excel cell is returning 1or 0 but in the formula tab it is displaying the answer correctly, any idea what might be the issue at play?
Make sure that the number format of column K is set to General or to Number with at least one decimal place.