I have several excel spreadsheets(2007) where i use the statement =IF(B7=",",(B7-B6)) which is saying if B7 is empty then display 0 otherwise B7-B6 is displayed. This is working correctly for me in those spreadsheets. I have now created another spreadsheet and i am trying to use the same formula but the answer returns False.
I guess there must be some setting or something that is different to the other spreadsheets i have created. Can anyone tell me why its returning False instead of the number i want to see.
I guess there must be some setting or something that is different to the other spreadsheets i have created. Can anyone tell me why its returning False instead of the number i want to see.