Excel returning 1 or 0 instead of actual calculation results

[chinmaycm]

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?

[#2]

@chinmaycm 

Make sure that the number format of column K is set to General or to Number with at least one decimal place.