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 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

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