[Solved] Multiple IF function in one cell

[dojo97]

If have this IF statement

Code: Select all

=IF(AND(H6>R6;R6>S6;S6>U6);"Uptrend-Bluesky") =IF(AND(H6<R6;R6>S6;S6>U6);"Uptrend-Retrace") =IF(AND(R6<S6;S6>U6);"Reset") =IF(AND(R6>S6;S6<U6);"Reversal")

that only gives "TRUE" or "FALSE" answer. The answers I need to come out are "Uptrend-Bluesky", "Uptrend-Retrace", "Reset" and "Reversal"

Need help!

[robleyd]

Your syntax needs to be like this:

Code: Select all

=IF (F1=5;"this"; IF (F1=4;"that"; IF (f4=3;"other"); "default"))

without all the = before the second and subsequent IF functions.

[dojo97]

I tried this . .

=IF (H6>R6;R6>S6;S6>U6;"Uptrend-Bluesky"; IF(H6<R6;R6>S6;S6>U6;"Uptrend-Retrace"; IF(R6<S6;S6>U6;"Reset";IF(R6>S6;S6<U6;"Reversal");"default")))

and it gives out Err504


When I added the "(AND" and ")"
=IF (AND(H6>R6;R6>S6;S6>U6);"Uptrend-Bluesky"; IF(AND(H6<R6;R6>S6;S6>U6);"Uptrend-Retrace"; IF(AND(R6<S6;S6>U6;"Reset"); IF(AND(R6>S6;S6<U6;"Reversal");"default"))))
--> result: #Value!

[Zizi64]

In this case you must put the nested IF into the position of the FALSE answer.
=IF(the first condition;result when TRUE;result when FALSE)

=IF(the first condition;result when TRUE;IF(the second condition;result when TRUE;result when FALSE))

...and so on.

[Zizi64]

Please upload your ODF type sample file here.

[Zizi64]

=IF (H6>R6;R6>S6;S6>U6;"Uptrend-Bluesky"; IF(H6<R6;R6>S6;S6>U6;"Uptrend-Retrace"; IF(R6<S6;S6>U6;"Reset";IF(R6>S6;S6<U6;"Reversal");"default")))

You missed the logical AND function from the multiple conditions.

[dojo97]

Attaching my spreadsheet . . . .

[robleyd]

Code: Select all

=IF(AND(H6>R6;R6>S6;S6>U6);"Uptrend-Bluesky";
IF(AND(H6<R6;R6>S6;S6>U6);"Uptrend-Retrace";
IF(AND(R6<S6;S6>U6);"Reset";
IF(AND(R6>S6;S6<U6);"Reversal";
"default"))))

Doesn't give an error and shows default when all of H6, R6, S6 and U6 are empty. You can copy that as is - Calc will convert the formula to one line; just make sure there are no leading spaces when you paste if you use the SELECT ALL option on the code box.

[dojo97]

THANKS Bro!!!

My head was spinning with these syntax . . . .

[robleyd]

Pro tip; break it down into small steps and do one step at a time, each step ensuring the syntax is correct. I find it easier sometimes to construct the formula, step by step, as multi-line text in a simple text editor then copy into Calc.