This might be the most insane question I have ever asked. But can someone please tell me why 1-1 isn’t 0…. I have been working for the past 19 hours straight so that might have something to do with it but it seems whenever I change the order of the cells that I am adding up to equal 1 that in some orders excel doesnt seem to see them as adding up to 1. Please see attached. Im losing my mind haha

​This might be the most insane question I have ever asked. But can someone please tell me why 1-1 isn’t 0…. I have been working for the past 19 hours straight so that might have something to do with it but it seems whenever I change the order of the cells that I am adding up to equal 1 that in some orders excel doesnt seem to see them as adding up to 1. Please see attached. Im losing my mind haha  Read More

​