Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Add & Substract in One Cell
Hello.
I am trying to setup a log for number of SMS sent. It will be in 3 columns. Example: Column A would have the total number of credits; Column B would have credits received from the Phone Company; Column C would have the debits (SMSs sent). For example let's say that A2 has a start value of 1000. When I enter 200 in B2, A3 should say 1200. If I enter 400 in C3, A4 should say 800. All the changes should happen in Column A based on info I enter in Columns B and C. How would I go about doing this? How should I make it so that atleast 100 rows in Column A has this function? Please advise. Ram. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Add & Substract in One Cell
Hi Ram
i would set it up like this Row 1: Titles A2: Start amount A3: following function: =if(and(B2="",C2=""),"",A2+B2-C2) then select A3, and drag the formula down as far as you want to. hth Carlo On Jan 8, 4:28*pm, rampiranha wrote: Hello. I am trying to setup a log for number of SMS sent. It will be in 3 columns.. Example: Column A would have the total number of credits; Column B would have credits received from the Phone Company; Column C would have the debits (SMSs sent). For example let's say that A2 has a start value of 1000. When I enter 200 in B2, A3 should say 1200. If I enter 400 in C3, A4 should say 800. All the changes should happen in Column A based on info I enter in Columns B and C. How would I go about doing this? How should I make it so that atleast 100 rows in Column A has this function? Please advise. Ram. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Add & Substract in One Cell
Great Stuff...
Workis like Magic... Big Thank You Carlo... "carlo" wrote: Hi Ram i would set it up like this Row 1: Titles A2: Start amount A3: following function: =if(and(B2="",C2=""),"",A2+B2-C2) then select A3, and drag the formula down as far as you want to. hth Carlo On Jan 8, 4:28 pm, rampiranha wrote: Hello. I am trying to setup a log for number of SMS sent. It will be in 3 columns.. Example: Column A would have the total number of credits; Column B would have credits received from the Phone Company; Column C would have the debits (SMSs sent). For example let's say that A2 has a start value of 1000. When I enter 200 in B2, A3 should say 1200. If I enter 400 in C3, A4 should say 800. All the changes should happen in Column A based on info I enter in Columns B and C. How would I go about doing this? How should I make it so that atleast 100 rows in Column A has this function? Please advise. Ram. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Add & Substract in One Cell
You're welcome and thanks for the feedback
Carlo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to substract a date in excel to 2000 | Excel Programming | |||
Need formula in Excel to substract cell D from Cell C | New Users to Excel | |||
How do I substract numbers in range like this: Substract(a1..a10) | New Users to Excel | |||
substract cell F from cell H and total into cell I | Excel Worksheet Functions | |||
how do i substract in microsoft excel? | Excel Worksheet Functions |