| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Subtracting
I need to subract B3 through U3 from 410. I can't figure out how to do it.
Thanx |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Subtracting
In article ,
says... I need to subract B3 through U3 from 410. I can't figure out how to do it. Thanx Suppose you want the result in B4:U4. Then, in B4 enter =410-B3. Copy B4 to C4:U4. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Subtracting
You can do the following:
Enter the formula =sum(B3:U3) in a empty cell say B14 Then substarct =B14-410, B14 is total sum of B3:U3 Challa Prabhu "Tushar Mehta" wrote: In article , says... I need to subract B3 through U3 from 410. I can't figure out how to do it. Thanx Suppose you want the result in B4:U4. Then, in B4 enter =410-B3. Copy B4 to C4:U4. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| Decimal places and subtracting | Excel Discussion (Misc queries) | |||
| What is the formula for subtracting the sum total of two cells | Excel Discussion (Misc queries) | |||
| adding and subtracting using vb code | Excel Discussion (Misc queries) | |||
| Deleting time part of a Date, subtracting dates | Excel Discussion (Misc queries) | |||
Linear Mode
