Log In
Register
Home
IF and NOT FUNCTION
Dieneba NDIAYE
Member
Members
Power BI
Power BI
Forum Posts: 39
Member Since:
April 22, 2022
April 22, 2022
Offline1
January 10, 2023 - 10:28 pm
Hi
I am not quite clear on the use of the this nested function. Could you kindly give another example.
Regards
Catalin Bombea
Iasi, Romania
Admin
Forum Posts: 1824
Member Since:
November 8, 2013
November 8, 2013
Offline2
January 12, 2023 - 3:51 pm
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: 245
Currently Online: Kelly Andrews
Guest(s) 9
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Charles DeGraffenreaid
Cathi Giard
Sarah Young
Henry Delgado
Alita Nieuwoudt
KL KOH
Joao Marques
Regi Hampton
Taffie Elliott
Paramita Chakraborty
Forum Stats:
Groups: 3
Forums: 24
Topics: 6359
Posts: 27806
Member Stats:
Guest Posters: 49
Members: 32336
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —