Else If

[raysefo]

Hi,

Is it possible to use

IF()
ELSE IF()
ELSE IF() block? and how to use?

Lets say i have a cell, and wanna use if else block.
if (A1 > 1,25;true;false) else if(A1 > 1,33;true;false) etc.

[Carim]

Hi,

If you are talking about Formulas ... the answer is No
you have to "nest" your IF's i.e. =If(x=y,z,If(a=b,c,d))

If you are talking about VBA ... the answer is Yes
do not forget the End If

HTH
Carim

[raysefo]

Hi,

i wrote something like this;

=IF(C2>1,25;"UPPER";"";IF(C2<1,33;"UPPER";""))

But it says too many independent variables!

[Carim]

Hi,

you wrote :
=IF(C2>1,25;"UPPER";"";IF(C2<1,33;"UPPER";""))

first is your separator , or ; select the adequate one

What does "UPPER" mean to you ... ?
Do you have more than 2 instances otherwise
=IF(C2>1,25,33)

HTH
Carim

[raysefo]

Hello,

first of all my seperator is ; and its true! when i use (,) it gives error. Anyway dont bother with "UPPER" just tell me how to use the statement correctly,
.

=EĞER(C2>1,25;"true";"false";EĞER(C2<1,33;"true";"false"))

in this statement the cell has o be the same which is C2! and as i said b4 it says too many variables...

[Carim]

=EĞER(C2>1,25;"true";EĞER(C2<1,33;"true";" false"))


HTH
Carim