#### Topic: Some conditions if

Children! Help to understand conditions, I was tangled!

``=IF (D17 = ""; IF (F17&gt; =180; ""; ""); IF (D17 = ""; IF (F17&gt; =56; IF (F17 &lt;80; ""; ""); ""); IF (I17 = "IS closed"; ""; "")))``

#### Re: Some conditions if

Take a pencil yes ornament, .

assei wrote:

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

Ingeniously...

#### Re: Some conditions if

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

#### 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

#### 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&gt; 180); And (1 = ""; E1&gt; 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&gt; 180); And (1 = ""; E1&gt; 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&gt; 180); And (C1 = ""; E1&gt; 70)); ""; "")))``

Well and everything, .

#### Re: Some conditions if

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

#### Re: Some conditions if

assei wrote:

Children! Help to understand conditions, I was tangled!

``=IF (D17 = ""; IF (F17&gt; =180; ""; ""); IF (D17 = ""; IF (F17&gt; =56; IF (F17 &lt;80; ""; ""); ""); IF (I17 = "IS closed"; ""; "")))``

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

#### Re: Some conditions if

Focha, thanks for council!