1

Topic: Some conditions if

Children! Help to understand conditions, I was tangled!

=IF (D17 = ""; IF (F17> =180; ""; ""); IF (D17 = ""; IF (F17> =56; IF (F17 <80; ""; ""); ""); IF (I17 = "IS closed"; ""; "")))

2

Re: Some conditions if

Take a pencil yes ornament, .

assei wrote:

IF (I17 = "IS CLOSED"; ""; "")

Ingeniously...

3

Re: Some conditions if

Akina, probably it was cheerful on a holiday?))))) yes  that.....

4

Re: Some conditions if

Akina, it is impossible to me, prompt as further that at me turned out in an EXAMPLE, two conditions to connect in one formula

5

Re: Some conditions if

Apprx. Allow to build the graph of variants.
First of all we check 1 = "IS closed" because remaining variants do not depend from 1 and as I understand, are superimposed by this condition.

IF (1 = "IS closed"; ""; )

It is better to make the following check check on "" - there simple equality. Check only this stage looks as

IF (OR (And (1 = ""; E1=180); And (1 = ""; E1=70)); ""; )

And after substitution in initial check it is received

IF (1 = "IS closed"; ""; IF (OR (And (1 = ""; E1 = 180); And (1 = ""; E1 = 70)); ""; ))

And now in general all the same, on what to fulfill check... Well give it is possible on "PfRf".

IF (OR (And (1 = ""; E1> 180); And (1 = ""; E1> 70)); ""; )

After substitution in the previous expression it is received

IF (1 = "IS closed"; ""; IF (OR (And (1 = ""; E1 = 180); And (1 = ""; E1 = 70)); ""; IF (OR (And (1 = ""; E1> 180); And (1 = ""; E1> 70)); ""; )))

Well and as all OstalnyeVarianty is a blank line it is is final had

=IF (A1 = "IS closed"; ""; IF (OR (And (C1 = ""; E1 = 180); And (C1 = ""; E1 = 70)); ""; IF (OR (And (C1 = ""; E1> 180); And (C1 = ""; E1> 70)); ""; "")))

Well and everything, .

6

Re: Some conditions if

Akina, at it is much grateful! There is still a question with the filter but it in a following question!

7

Re: Some conditions if

assei wrote:

Children! Help to understand conditions, I was tangled!

=IF (D17 = ""; IF (F17> =180; ""; ""); IF (D17 = ""; IF (F17> =56; IF (F17 <80; ""; ""); ""); IF (I17 = "IS closed"; ""; "")))

At writing of formulas use alt+enter (transfer of a line) and it will be convenient

8

Re: Some conditions if

Focha, thanks for council!