how to inplement "if then else"

L

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
 
J

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
 
G

Guest

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