how to inplement "if then else"

[Leo Kerner]

Can somebody tell me how to implement "if then else" structures in
excel?
Something like

if C3 < 56 then B1= function_1
else if (C3 > 56 AND C3 <100) then B1 = function_2
else B1 = funcion_3

Thanks.

Leo

[JE McGimpsey]

one way:

B1: =IF(C3<=56, function_1, IF(C3<100, function_2, function_3))

note that you don't have give a result for C3 = 56, so I assumed that it
should return function_1

In article <4216326D.7DE813D0@sympatico.ca>,
Leo Kerner <l.kerner@sympatico.ca> wrote:

> Can somebody tell me how to implement "if then else" structures in
> excel?
> Something like
>
> if C3 < 56 then B1= function_1
> else if (C3 > 56 AND C3 <100) then B1 = function_2
> else B1 = funcion_3
>
> Thanks.
>
> Leo

hi
if Range("C3") < 56 then
Range("B1").value = "Function_1"
else
if Range("C3") > 56 AND Range("C3") < 100 then
Range("B1").value = "Function_2"
else
Range("B1").value = "Functions_3"
end if
end if
this would be the sturcture but i think it still may give
to problems. i don't know what these functions are.
Post back with more info if you have problems.

>-----Original Message-----
>Can somebody tell me how to implement "if then else"
structures in
>excel?
>Something like
>
>if C3 < 56 then B1= function_1
> else if (C3 > 56 AND C3 <100) then B1 = function_2
> else B1 = funcion_3
>
>Thanks.
>
>Leo
>
>.
>