#1
Hey guys, I need some help with excel for one of my classes. This is the IF equation we are supposed to use = IF( <cell> = “”, “”, < balance formula >. Here is what my spreadsheet looks like.

Ok so I want to know how to get the balance to add up automatically using the above equation. Thanks a lot
#2
You've spelt 'withdrawl' wrong. Other than that I can't help.
Originally posted by TestForEcho
Badreligionrock is the man.

Quote by Pinky19
Badreligionrock you have the greatest avatar of all time. Rejected is the best video. Period.
#3
what do you mean you just want to add some cells together? what are you usinf the If for
Main Rigs
Guitars
Thineline tele with SD lil '59

Ibanez Artcore AM-73

Line 6 Variax 500


Effects

Line 6 X3 live
Digitech RP-500
Ibanez Weeping Demon


Amps
Roland JC-120
Rocktron VT-60
#4
Quote by teknotard
what do you mean you just want to add some cells together? what are you usinf the If for


thats what my teacher told us to use, it should looks something like this

=IF(A2=100,SUM(B5:B15),"")
#5
Well, I would just do the followinf
=If(D4>0,D4+I3, I3-F4)

THen just fill all the way down.
What this does is say if you have deposit it will added it to the balance becasue there is a value. Otherwise the Line must be a withdrawl in which case it subtracts it from the balance
Main Rigs
Guitars
Thineline tele with SD lil '59

Ibanez Artcore AM-73

Line 6 Variax 500


Effects

Line 6 X3 live
Digitech RP-500
Ibanez Weeping Demon


Amps
Roland JC-120
Rocktron VT-60
#6
ok thanks ill see if it works

yes that worked thankyou very much

may the guitar gods shine above you today
#7
hahahah im glad!

THanks
Main Rigs
Guitars
Thineline tele with SD lil '59

Ibanez Artcore AM-73

Line 6 Variax 500


Effects

Line 6 X3 live
Digitech RP-500
Ibanez Weeping Demon


Amps
Roland JC-120
Rocktron VT-60