| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 columns need one figure substracted from another cell
No doubt this is easy, but knew to excel..
Have a row with 2 scores. ie c5 & e5, wish to subtract c5 from 72 and have answer in d5 and subtract e5 from 72 and have answer in f6... would like to drag formula down for all 40 rows thanks for anyones help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2 columns need one figure substracted from another cell
On Feb 11, 10:00*pm, "poncho" <u49547@uwe wrote:
No doubt this is easy, but knew to excel.. Have a row with 2 scores. ie c5 & e5, wish to subtract c5 from 72 and have answer in d5 and subtract *e5 from 72 and have answer in f6... would like to drag formula down for all 40 rows thanks for anyones help. In D5 enter =72-C5 in F6 enter =72-E5 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2 columns need one figure substracted from another cell
Thanks Curly Dave, cant believe that it was that simple, looking for
something difficult i guess Thanks Heaps CurlyDave wrote: No doubt this is easy, but knew to excel.. Have a row with 2 scores. ie c5 & e5, wish to subtract c5 from 72 and have answer in d5 and subtract Â*e5 from 72 and have answer in f6... would like to drag formula down for all 40 rows thanks for anyones help. In D5 enter =72-C5 in F6 enter =72-E5 -- poncho Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200902/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE | Excel Worksheet Functions | |||
| Formatting columns with either a date OR a numerical figure | Excel Worksheet Functions | |||
| how to find negative figure in various columns and rows | Excel Discussion (Misc queries) | |||
| cell * figure | Excel Discussion (Misc queries) | |||
| 1-7 Columns, to find last column with figure in | Excel Worksheet Functions | |||
Hybrid Mode
