Ask Your Question
0

calc formula/ code help [closed]

asked 2014-01-20 23:27:04 +0200

RadioSeanUK gravatar image

updated 2014-01-21 02:06:03 +0200

oweng gravatar image

Hi I am writing this for a family member, I have also added a image to help me.

He wants data 2 to be subtracted from data 1 and shown the answer in the next row of data 2.

he will be adding to this sheet every month so I'm after a code that will repeat the said formula.

image description

Sorry if I have not expand myself feel free to ask any follow up questions

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 16:58:58.602371

Comments

"he will be adding to this sheet every month so I'm after a code that will repeat the said formula." How will this be added? Are lines 3-4 a repetition of the model of 1-2? OR is line 3 the Feb data that gets subracted from "Data1" as well? Much copy/paste in calc with "autoadjust", but the pattern you have in mind will make a difference. Can you explain how the next set of rows will appear?

David gravatar imageDavid ( 2014-01-21 14:30:48 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2014-01-21 01:52:44 +0200

m.a.riosv gravatar image

Write in the cell in what you want the answer.

=B1-B2

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-01-20 23:27:04 +0200

Seen: 62 times

Last updated: Jan 21 '14