Adding Cell to the left
 

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

Adding Cell to the left
 

Enter this formula in T57:

=IF(COUNT(R57),Q57+S57,"")

If R57 does not contain a number then T57 will remain blank.

--
Biff
Microsoft Excel MVP


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

Adding Cell to the left
 

So if R57 is nothing then T57 is nothing
So if R57 is a number then put Q57+S57 into T57


In T57,enter:
=IF(R57="","",Q57+S57)
--
Gary''s Student - gsnu2007k

Adding Cell to the left
 

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