Excel returning 1 or 0 instead of actual calculation results

Copper Contributor

Screenshot 2023-08-31 233531.png

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.