Y yaya Mar 20, 2010 #1 this is function =IF((C2=25);C3=0;(C3=(C2+5))) and it still alwas give me false what is the error?
H Hakyab Mar 22, 2010 #2 The function, =IF((C2=25);C3=0;(C3=(C2+5)) will return a TRUE of FALSE depending on whether C3 = 0, when C2 is 25. If you want it to return 0, or C2+5, you should use =IF((C2=25);0;C2+5) in cell C3. HTH
The function, =IF((C2=25);C3=0;(C3=(C2+5)) will return a TRUE of FALSE depending on whether C3 = 0, when C2 is 25. If you want it to return 0, or C2+5, you should use =IF((C2=25);0;C2+5) in cell C3. HTH