IF Statement

[Elsaboy]

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.

 

[sunny102]

use this

=IF(B7="","",(B7-B6))

 

[Elsaboy]

Thanks for that. It seems i need to get my glasses changed as that is how the original formula was wrote. I have never really understood how the formula works, it was something i copied from someone else's spreadsheet years ago.

 

[Scott T]

This video may help you understand zero lenght text strings
https://youtu.be/HdkL_VcWtCI