Attn to Mr Hans Vogelaar

%3CLINGO-SUB%20id%3D%22lingo-sub-2223195%22%20slang%3D%22en-US%22%3EAttn%20to%20Mr%20Hans%20Vogelaar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2223195%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Hans%3C%2FP%3E%3CP%3Ethe%20And%20and%20Or%20If%20Functions%20I'm%20using%2C%20for%20checks%2C%20in%20the%20attached%20file%20are%20working%20perfectly%3B%20new%20identical%20functions%20could%20not%20be%20made%20functional%20in%20the%20same%20file%20for%20new%20checks.%20Hope%20it's%20well%20summarised%20and%20clear%20now.%26nbsp%3B%20I'm%20afraid%20I%20don't%20know%20how%20to%20reply%20by%20email%20(it's%20not%20delivered%20to%20you)%20and%20I'don't%20know%20how%20to%20keep%20the%20discussion%2C%20so%20I'm%20creating%20a%20new%20ticket.%20Thanks%20in%20advance%20Regards%3C%2FP%3E%3CP%3EHi%20Hans%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20have%20been%20of%20great%20help%20weeks%20ago%20on%20Macros%20and%20I%20thank%20you%20again%20for%20that%3B%3C%2FP%3E%3CP%3Eyou%20save%20me%20a%20lot%20of%20time%20avoiding%20to%20rewrite%20Macros.%3C%2FP%3E%3CP%3EI'm%20sure%20you%20will%20be%20of%20great%20help%20again.%3C%2FP%3E%3CP%3EIssue%20today%20is%20with%20IF%20functions%3A%3C%2FP%3E%3CP%3EAND)%20when%20adding%20new%20data%20to%20a%20file%2C%20I%20need%20to%20ensure%20new%20%22names%22%20are%20the%20same%20as%20existing%20%22names%22%2C%20sorted%20equally%2C%20to%20avoid%20mixing%20data%20per%20%22name%22%2C%20which%20would%20mean%20data%20useless%3B%3C%2FP%3E%3CP%3EOR%20)%20to%20notice%20when%20data%20per%20name%20is%20fixed%2C%20in%20this%20case%20over%20a%20period%20of%203%20entries.%3C%2FP%3E%3CP%3EI'm%20attaching%20an%20extraction%20of%20my%20file%2C%20where%20several%20of%20these%20checks%20are%20done.%3C%2FP%3E%3CP%3EAs%20mentioned%20in%20my%20request%2C%20when%20introducing%20a%20new%20check%2C%20function%20was%20not%20reacting%20as%20I%20was%20expecting%2C%20implying%20the%20checks%20were%20not%20done.%3C%2FP%3E%3CP%3EI%20remember%20now%2C%20that%20this%20week%20an%20update%20of%20Windows%20occurred%2C%20shifting%20Office%20into%20365%3B%3C%2FP%3E%3CP%3EOffice%20is%20now%20back%20to%20version%20I%20bought%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20support%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EDe%20%3A%3C%2FSTRONG%3E%26nbsp%3BMicrosoft%20Tech%20Community%20%3CMICROSOFTTECHCOMMUNITY%3E%3CBR%20%2F%3E%3CSTRONG%3EEnvoy%C3%A9%20%3A%3C%2FSTRONG%3E%26nbsp%3Bvendredi%2019%20mars%202021%2014%3A57%3CBR%20%2F%3E%3CSTRONG%3E%C3%80%20%3A%3C%2FSTRONG%3E%26nbsp%3Bjorge.m.leitao%40outlook.com%20%3CJORGE.M.LEITAO%3E%3CBR%20%2F%3E%3CSTRONG%3EObjet%20%3A%3C%2FSTRONG%3E%26nbsp%3BHans%20Vogelaar%20mentioned%20you%20in%20Microsoft%20Tech%20Community%3C%2FJORGE.M.LEITAO%3E%3C%2FMICROSOFTTECHCOMMUNITY%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20JorgeLx%2C%3C%2FP%3E%3CP%3EHans%20Vogelaar%20(MVP)%20mentioned%20you%20in%20a%20post!%20Join%20the%20conversation%20below%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fmultiple-if-function%2Fm-p%2F2222862%2Femcs_t%2FS2h8ZW1haWx8bWVudGlvbl9zdWJzY3JpcHRpb258S01HREFCOTNPN0NRSDd8MjIyMjg2MnxBVF9NRU5USU9OU3xoSw%23M93566%22%20target%3D%22_blank%22%3E%3CSTRONG%3ERe%3A%20Multiple%20IF%20Function%3C%2FSTRONG%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F976623%3Femcs_t%3DS2h8ZW1haWx8bWVudGlvbl9zdWJzY3JpcHRpb258S01HREFCOTNPN0NRSDd8MjIyMjg2MnxBVF9NRU5USU9OU3xoSw%22%20target%3D%22_blank%22%3E%40JorgeLx%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20condition%20such%20as%20D7%3DE7%3DF7%20won't%20do%20what%20you%20want.%20It%20is%20equivalent%20to%20(D7%3DE7)%3DF7%2C%20so%20it%20is%20TRUE%20if%20D7%3DE7%20and%20F7%3DTRUE%20or%20if%20D7%26lt%3B%26gt%3BE7%20and%20F7%3DFALSE.%3C%2FP%3E%3CP%3EAnd%20the%20closing%20parenthesis%20of%20OU(...)%20is%20placed%20incorrectly.%3C%2FP%3E%3CP%3EIt%20should%20be%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSI(OU(ET(D7%3DE7%3BD7%3DF7)%3BET(D8%3DE8%3BD8%3DF8))%3B%22yes%22%3B%22no%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20used%20to%20If%20Functions%2C%20And%20and%20Or%2C%20on%20multiple%20version%20(ex%3A%20%3DSI(OU(D7%3DE7%3DF7%3BD8%3DE8%3DF8%3B...%3B%22yes%22%3B%22no))%3B%20in%20some%20cases%20to%20check%20numbers%2C%20in%20others%20to%20check%20text%2C%20names%20eventually%20alphanumeric%3B%20it%20may%20happen%20that%20cells%20with%20text%20are%20declared%20has%20numbers%20(if%20I%20have%20to%20insert%20columns%2C%20for%20numbers%2C%20immediately%20afterwards)%3B%3C%2FP%3E%3CP%3Eall%20of%20a%20sudden%2C%20implementing%20a%20new%20function%20it%20doesn't%20work%20in%20a%20new%20sheet%2C%20at%20all%3B%20previous%20ones%2C%20in%20other%20sheets%20keep%20functioning%20correctly%3B%26nbsp%3B%20no%20change%20of%20the%20pc%2C%20Windows%20or%20Office%20versions%3B%20the%20excel%20file%20has%20now%20less%20than%206KB%2C%20less%20than%2040%20sheets%2C%20in%20some%20sheets%20some%20600%20columns%2C%20in%20some%20sheets%20some%20600%20lines.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2223195%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi Hans

the And and Or If Functions I'm using, for checks, in the attached file are working perfectly; new identical functions could not be made functional in the same file for new checks. Hope it's well summarised and clear now.  I'm afraid I don't know how to reply by email (it's not delivered to you) and I'don't know how to keep the discussion, so I'm creating a new ticket. Thanks in advance Regards

Hi Hans

 

you have been of great help weeks ago on Macros and I thank you again for that;

you save me a lot of time avoiding to rewrite Macros.

I'm sure you will be of great help again.

Issue today is with IF functions:

AND) when adding new data to a file, I need to ensure new "names" are the same as existing "names", sorted equally, to avoid mixing data per "name", which would mean data useless;

OR ) to notice when data per name is fixed, in this case over a period of 3 entries.

I'm attaching an extraction of my file, where several of these checks are done.

As mentioned in my request, when introducing a new check, function was not reacting as I was expecting, implying the checks were not done.

I remember now, that this week an update of Windows occurred, shifting Office into 365;

Office is now back to version I bought 

Thank you for your support 

Regards 

De : Microsoft Tech Community <MicrosoftTechCommunity@us.khoros-mail.com>
Envoyé : vendredi 19 mars 2021 14:57
À : jorge.m.leitao@outlook.com <jorge.m.leitao@outlook.com>
Objet : Hans Vogelaar mentioned you in Microsoft Tech Community

 

Hi JorgeLx,

Hans Vogelaar (MVP) mentioned you in a post! Join the conversation below:

Re: Multiple IF Function

@JorgeLx 

A condition such as D7=E7=F7 won't do what you want. It is equivalent to (D7=E7)=F7, so it is TRUE if D7=E7 and F7=TRUE or if D7<>E7 and F7=FALSE.

And the closing parenthesis of OU(...) is placed incorrectly.

It should be

 

=SI(OU(ET(D7=E7;D7=F7);ET(D8=E8;D8=F8));"yes";"no")

 

Hello

 

I'm used to If Functions, And and Or, on multiple version (ex: =SI(OU(D7=E7=F7;D8=E8=F8;...;"yes";"no)); in some cases to check numbers, in others to check text, names eventually alphanumeric; it may happen that cells with text are declared has numbers (if I have to insert columns, for numbers, immediately afterwards);

all of a sudden, implementing a new function it doesn't work in a new sheet, at all; previous ones, in other sheets keep functioning correctly;  no change of the pc, Windows or Office versions; the excel file has now less than 6KB, less than 40 sheets, in some sheets some 600 columns, in some sheets some 600 lines.

1 Reply

@JorgeLx 

You asked the same question in Attn to Mr Hans Vogelaar and I posted a request for clarification there.

There is a Reply link at the bottom of each post.