Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

LibreOffice Calc

Conor108 · 2011-10-02 13:24:20

This is probably really basic but I cannot for the life of me do it. I have 2 columns of 50 rows. Column A has a number in each row and I need column B to have the number in it's row's A column minus a constant. Like B3 needs to be equal to A3 - constant. How do I make a function to do this automatically for each row?

02-10-2011 01:24PM

#1

Conor108

Registered Users, Registered Users 2 Posts: 3,871 ✭✭✭

Join Date: October 2006

Posts: 3571

This is probably really basic but I cannot for the life of me do it.

I have 2 columns of 50 rows. Column A has a number in each row and I need column B to have the number in it's row's A column minus a constant.

Like B3 needs to be equal to A3 - constant. How do I make a function to do this automatically for each row?

0

Comments

#2 02-10-2011 07:02PM

Capt'n Midnight

Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 96,176 Mod ✭✭✭✭

Join Date: March 2003

Posts: 94413

$ is used for absolute reference

put the constant in cell c1

then the formula for cell B2 is =a1-$c$1

then copy that cell down

0