Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
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 . |