RE add cells together if value has a formula
 

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

Hi!

MID(C27,5,1)

I have to use the MID funtion to extract a single number from 11400 all in
one cell

MID is a TEXT function and returns TEXT even if the referenced cell is
numeric. You can convert the TEXT number to a true numeric number like this:

=--MID(C27,5,1)

Based on the formula and the referenced cell value of 11400, the returned
result will be 0.

Biff

"bill gras" wrote in message
...
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