I have in cell F26 formulas that produce numbers 0-24 when I add two cells
together providing that F26 =1 the two cells add together do not give the
result according to the formula.
eg: =IF(F26=0,K52,K52+J52) this formula only adds K52+J52 but does not give
K52 on its own if F26=1 I think it is because F26 has a formula
MID(C27,5,1) which gives the answer of 1 I have to use the MID funtion to
extract a single number from 11400 all in one cell

please help
thaks
bill gras