LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ADDING WORDS TO THE LEFT SIDE OF AN EXCEL SHEET Susan Excel Discussion (Misc queries) 2 October 26th 06 03:16 PM
ADDING/SUBTRACTING FROM RIGHT TO LEFT Joanne Excel Worksheet Functions 6 July 28th 06 07:25 PM
How to point to (select) a cell to the left from a cell where I enter the = equal sign? Dmitry Excel Discussion (Misc queries) 4 June 30th 06 06:49 AM
Adding a period to the "=LEFT()" function. Stilla Excel Worksheet Functions 8 February 8th 06 09:46 PM
adding 0's to the left side of a constant number cell faisal alfadl Excel Discussion (Misc queries) 1 November 25th 05 05:07 PM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"