Else If

R

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

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
 
R

raysefo

Hi,

i wrote something like this;

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

But it says too many independent variables!
 
C

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
 
R

raysefo

Hello,

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