Excel

Advertise at AfterDawn.com

Link to us!

Private messages

Compose a private message

List of all updated threads

Threads without replies

Search messages

Wednesday 13.8.2025 / 16:56

Search AfterDawn Forums:

afterdawn.com > forums > software, operating systems and more > windows - software discussion > excel

Browse by topic

Forums

Start a new thread

Excel

Jump to:

Posted

Message

Paracite

Junior Member

31. October 2007 @ 12:06

Link to this message

Heyah, i'm trying to setup an Excel file, i've got 2 columns (b and C), and each column will have/has 64 rows of info...
this is what i'm looking for: I.ex: every month i enter an ammount on each row (column B), (different ammounts) 200, 204,67 206,89... and so on. In Column C i want to make a formula that counts 300 - (minus) the ammount i enter in B and would then count the SUM. Ok here comes the part i need help in, is there a way to get the formulas "triggered" when i enter the ammount in B, because the comming 50 rows in B have a value of 0, using the formula makes the same rows in C with a value of 300. Both columns are being auto summned at the bottom, and that's why i need the exact ammount in both rows!

OMG, this is sooo hard to explain :)
So in short again, :) when i enter an ammount in Col b, i want the formula to be triggered and enter the correct ammount in Col C, is this even possible?

I really hope i made any sence in this one, lol!
~Cheerz~

[ + quote]

itpro1000

Suspended due to non-functional email address

1. November 2007 @ 18:14

Link to this message