#### 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"; ""; "")))`

You are not logged in. Please login or register.

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"; ""; "")))`

Take a pencil yes ornament, .

assei wrote:

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

Ingeniously...

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

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

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, .

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

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

Focha, thanks for council!

**Random topics**