Excel help required

[surreal trip]

Bloody excel formulas.... I need to find a formula that will help me pre-populate a given cell with information that can be changed and updated without having to change every signle cell... for instance

A1= Auto Loan A2= 485.00
B1= Insurance B2= 390.00
and so on and so forth with about 7-8 different pre-populated variants

I'm looking for something where me even changing whats in A1 will change all of A1 and/or A2 or at least so that I wont have to re-type multiple fields or even multiple formulas... any suggestions for someone who has never used excel before?

 

[iCe]

i have something at home that may help however u need imput fields so yes by changing A1.B1...etc.. it will change your outcomes pretty simple for instance basic shit like say by clicking C1 and typing =A1+B1 then if u change either A1 or B1 same will follow and u can get more complicated from there

 

[surreal trip]

hmm ya I've got the basics off cell addition but what I'm lacking is a change code or input code for said cells... I think i've found the basics for having a subsidiary cell for numbers... but i dont know how to import letters from one cell to the next.... such a pain

 

[dead mike]

ctrl+c, ctrl+v should do it

ok.... so you want one cell to change all the numbers in the 2 column???

i think maybe u take A3 for your one input for all the cells.

in A2 you can put this =$A$3*B2 hit F4 to add those dollar signs

and copy that down, it should do some crazy shit with A3 times whatever in each cell

u can put whatver in J4 and everything else fills in

 

[BIOP]

I'm at work right now. But if you still need help later, hop on vent at 5 and I can talk you through it.

 

[skd_mrk]

I'd rather use a piece of paper over Excel.

I had to decipher some crazy algorithms a statistician and a pharmacist came up with for ordering drug quantities and price variances because their specifications didn't match their own results. It's not sexy in Oracle by any means, but at least you can read the code.