Forum Discussion
chinmaycm
Aug 31, 2023Copper Contributor
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?
1 Reply
Make sure that the number format of column K is set to General or to Number with at least one decimal place.