Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADDING WORDS TO THE LEFT SIDE OF AN EXCEL SHEET | Excel Discussion (Misc queries) | |||
ADDING/SUBTRACTING FROM RIGHT TO LEFT | Excel Worksheet Functions | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
Adding a period to the "=LEFT()" function. | Excel Worksheet Functions | |||
adding 0's to the left side of a constant number cell | Excel Discussion (Misc queries) |