Thread: [Solved] IF Statement (again)
View Single Post
 
Old 02-11-2022, 08:41 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Your mistake is confusing "0" and 0.
All strings between double quotes are text, the rest is number
As there are no text strings 0 you always get NC

Your values in col M, etc are numbers
This is obscured by the fact that you applied manual alignment probably for cosmetic reasons
You should avoid that when building your sheet, and only apply it on the finished product
Why ? Text is always left aligned in a cell and numbers always right-aligned. This feature helps finding mistakes
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote