enter the formula in T57= if(isnumber(R57),Q57+S57,"")


"cmatera" wrote:

R57 may or may not contain a #
If R57 contains a number I want to add the value of the cell to the
left of R57 so Q57 to the value of anothercell..lets say S57

So for example

Lets say R57 is 10

I want to add Q57(5) to the value in S57 (3) to make T57 = 8


any ideas how?

Thanks