Using if then else in Excel 2007

Hello,
I need help in writing a formula for on of the worksheets. It is kinda similar to my previous post -> http://www.excelforum.com/excel-prog...ml#post2546788

For K3:

IF(A3=A2) then (K3= (K2-J3)/100) Else (K3=(100-J3)/100)

Similarly,

For K4:
IF(A4=A3) then (K4= (K3-J4)/100) Else (K4=(100-J4)/100)

For K5:

IF(A5=A4) then (K5= (K4-J5)/100) Else (K5=(100-J5)/100)

and so on...

Could you please provide the correct syntax to use this logic?

Hi daymaker, my testing of the following code is on data that is meaningless so I cannot say for certain that it will do what your requirements imply but give it a try and let me know if it works:

Please Login or Register  to view this content.

Sorry, it's sporting an error in the calculations, try:

Please Login or Register  to view this content.

Actually, I think this might do it?
Place this in the cell at K3 and then drag down
=IF(A3=A2,((K2-J3)/100),((100 - J3)/100))

EDIT: The code from my previous 2 posts does not work correctly so please disregard it.