
Dieneba NDIAYE
Member
Members
Power Query
Power Pivot
Excel Expert
Power BI
Power Query
Power Pivot
Excel Expert
Power BI

Forum Posts: 12
Member Since:
April 22, 2022
April 22, 2022


Catalin Bombea
Iasi, Romania
Admin

Forum Posts: 1800
Member Since:
November 8, 2013
November 8, 2013

NOT returns the opposite of a logical condition.
Simply put, if your condition evaluates to TRUE, NOT TRUE will convert true to false.
Assuming that in cell A1 you have the value 45 and you want to perform an action when that cell is 45:
If Not Cells(1,1).Value45 then ' if A1 is not greater or smaller than 45
...
End if
Will return the same as:
If Cells(1,1).Value = 45 then ' if A1 equals 45
...
End if
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 170
Currently Online: Bouskila stephanie, James Hwang
Guest(s) 53
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1431
Anders Sehlstedt: 848
Velouria: 574
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 213
A.Maurizio: 202
Aye Mu: 201
Jessica Stewart: 185
Newest Members:
David Collins
Andras Marsi
Orimoloye Funsho
YUSUF IMAM KAGARA
PRADEEP PRADHAN
Vicky Otosnika
Abhishek Singh
Kevin Sojourner
Kara Weiss
And Woox
Forum Stats:
Groups: 3
Forums: 24
Topics: 6047
Posts: 26543
Member Stats:
Guest Posters: 49
Members: 31497
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Riny van Eekelen
© Simple:Press —
