I have a column in my Sharepoint list that for some reason doesn't seem to be calculating properly, it does however work in Excel. I am trying to get the result to put a zero if the choice column is "No". However the column is showing the calculated answer as if it has "Yes"(or not "No" for that matter) in it. The Formula is below.
The "Yes" and "No" are forced choices if that helps
As I say, the formula works in Excel but not in Sharepoint so I don't know where I am going wrong. I would appreciate any help!