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
|