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~
try using the If statement: IF(logical_test,value_if_true,value_if_false) or a nested if statement (IF(IF statement
