|
So, for the first time in my life, I had a need to use the IF function in Excel today at work. That was simple enough to figure out. But then I realized I needed to nest IF functions within IF functions to accomplish what I wanted. What a fucking nightmare. Took me 3 hours, but I think I finally figured the formula out. =IF(I2>0,IF(AND(K2>=0,M2>=0),I2-IF(AND(M2>=0,L2>=0),0,IF(M2>0,ABS(L2),0))-IF(AND(J2>=0,K2>=0),0,IF(K2>0,ABS(J2),0)),0),0) Anyone else have any Excel horror stories? EDIT: Oh yeah, this is the first IF function I used. I figured it would be all I needed for this sheet. Hell no. =IF(J2<0,J2+IF(I2>0,I2,0),J2)
Last Edit: Aug 2, 2010 18:45:02 GMT by Josh
|
|
|
|
The only problems I have with Excel is when I accidentally click it instead of MS Word. I really only use it to keep a record of my monthly expenses.
|
|
|
|
|
Don't use Excel. Use Mint for that.
|
|
|
|
Oooh, Mint is pretty. I might just start using it. Thanks
|
|
|
|
|
Excels formulas are horrible Especially when you have a conditional like that. They should really consider using a simplified version of visual basic for future versions of excel formulas.
|
k
|
|
|
|
Excels formulas are horrible Especially when you have a conditional like that. They should really consider using a simplified version of visual basic for future versions of excel formulas. You could just use VBA and grab information and output information to/from the cells...
|
|
|
|
|
never thought about that. lol
|
k
|
|
|
|
VBA is a horrific language. Do not try writing macros. I wanted to claw my eyes out. But yeah, I've had to write worse expressions Josh.
|
|
|
|
|
I don't really have any horror stories, but I also hate excel Lets start a FB group aha.
|
|
|
|
|
I love Excel. I just hated it when I made this thread and that formula was etched into my brain. lol
|
|
|
|
I love Excel. I just hated it when I made this thread and that formula was etched into my brain. lol at least you remembered it?
|
|
|
|
|
|
So this is a 1 year epic bump... but worthy of one. That bitch of a formula? I actually had to break it out today and modify a few greater than/less than symbols for another sheet I was putting together. That is actually quite awesome. Best part? I had the old file sitting in the recycling bin ready to be scrapped. Glad I didn't empty it.
|
|
|
|
Lucky. I'm surprised you wouldn't have had backups though.
Last Edit: Aug 15, 2011 20:05:30 GMT by Chris
|
|
|
|
|
We aren't allowed to. Most of what I do is military related. Can't make copies of any of it.
|
|
|