try type
=IF(A1="1",J6,J6+B6)
note apostrophes in 1
when you use mid the value in A1 is as text and not number

try this and see whether you get it.


bill gras wrote in message
...
In cell C7 I have 5 numbers (11400) I have extractet each number with the
MID
function and put them in cells A1 number 1 A2 number 1 A3 number 4 A4
number 0 A5 number 0 so A1 has the formula MID(C7,1,1) I need to add
two
cells together providing that cell A1=1 The formula I used
is:=IF(A1=1,J6,J6+B6) But what it does is , adds the cells j6+b6 which
should
be just j6 on its own. If I replace the cell A1 fomula MID(C7,1,1) with
just
number 1 it gives me the correct answer. I have tried different cell
formats.
Can any one tell me why?