Moderators: Tealer, Indaswamp, Dep6, #1wingnut, steve-o, Preacher1011, lostpup, La. Hunter
MackieKnife wrote:The moral of the story is...I'm retarded.
OmegaRed wrote:Can you use macros? Does it need done tonight?
MackieKnife wrote:The moral of the story is...I'm retarded.
MackieKnife wrote:The moral of the story is...I'm retarded.
MackieKnife wrote:The moral of the story is...I'm retarded.
MackieKnife wrote:The moral of the story is...I'm retarded.
go get the bird wrote:I fiddled with the numbers a bit, got it working.
Next question: Lets say none of those criteria are met (there is only one cell in the range with data). How can you get it to display which ever cell in the range is >0 instead of displaying "0"? It only works now if there a x+y or x-y situation.
whistlin_wings wrote:go get the bird wrote:I fiddled with the numbers a bit, got it working.
Next question: Lets say none of those criteria are met (there is only one cell in the range with data). How can you get it to display which ever cell in the range is >0 instead of displaying "0"? It only works now if there a x+y or x-y situation.
Instead of =IF(AND(A1>0,B1=0,C1>0,D1=0),A1+B1,IF(AND(A1>0,B1=0,C1=0,D1>0),A1-D1,IF(AND(A1=0,B1>0,C1=0,D1>0),B1+D1,IF(AND(A1=0,B1>0,C1>0,D1=0),B1-C1, 0))))
replace the 0 with "min" and select your range
=IF(AND(A1>0,B1=0,C1>0,D1=0),A1+B1,IF(AND(A1>0,B1=0,C1=0,D1>0),A1-D1,IF(AND(A1=0,B1>0,C1=0,D1>0),B1+D1,IF(AND(A1=0,B1>0,C1>0,D1=0),B1-C1,MIN(A1:D1)))))
MackieKnife wrote:The moral of the story is...I'm retarded.
MackieKnife wrote:The moral of the story is...I'm retarded.
go get the bird wrote:Not necessary, but thanks for the help.
This dilema was brought about because we are putting together an accounting spreadsheet that our instructor will make minor changes too, say an adjustment was recorded wrong, or the beginning balance of an account was off. All the numbers have to work when said changes are made. As of now, they are all working, at least through the adjusted trial balance. I'll work on the actual adjustments and the closing entries tonight.
Again, thanks for the !!
OGblackcloud wrote:go get the bird wrote:Not necessary, but thanks for the help.
This dilema was brought about because we are putting together an accounting spreadsheet that our instructor will make minor changes too, say an adjustment was recorded wrong, or the beginning balance of an account was off. All the numbers have to work when said changes are made. As of now, they are all working, at least through the adjusted trial balance. I'll work on the actual adjustments and the closing entries tonight.
Again, thanks for the !!
So in other words you used these guys to cheat
MackieKnife wrote:The moral of the story is...I'm retarded.
OGblackcloud wrote:go get the bird wrote:Not necessary, but thanks for the help.
This dilema was brought about because we are putting together an accounting spreadsheet that our instructor will make minor changes too, say an adjustment was recorded wrong, or the beginning balance of an account was off. All the numbers have to work when said changes are made. As of now, they are all working, at least through the adjusted trial balance. I'll work on the actual adjustments and the closing entries tonight.
Again, thanks for the !!
So in other words you used these guys to cheat
:
OGblackcloud wrote:
go get the bird wrote:Not necessary, but thanks for the help.
This dilema was brought about because we are putting together an accounting spreadsheet that our instructor will make minor changes too, say an adjustment was recorded wrong, or the beginning balance of an account was off. All the numbers have to work when said changes are made. As of now, they are all working, at least through the adjusted trial balance. I'll work on the actual adjustments and the closing entries tonight.
Again, thanks for the !!
So in other words you used these guys to cheat
I feel so used. Please inform me of your school and Professor's name so we can report you.
go get the bird wrote:whistlin_wings wrote:go get the bird wrote:I fiddled with the numbers a bit, got it working.
Next question: Lets say none of those criteria are met (there is only one cell in the range with data). How can you get it to display which ever cell in the range is >0 instead of displaying "0"? It only works now if there a x+y or x-y situation.
Instead of =IF(AND(A1>0,B1=0,C1>0,D1=0),A1+B1,IF(AND(A1>0,B1=0,C1=0,D1>0),A1-D1,IF(AND(A1=0,B1>0,C1=0,D1>0),B1+D1,IF(AND(A1=0,B1>0,C1>0,D1=0),B1-C1, 0))))
replace the 0 with "min" and select your range
=IF(AND(A1>0,B1=0,C1>0,D1=0),A1+B1,IF(AND(A1>0,B1=0,C1=0,D1>0),A1-D1,IF(AND(A1=0,B1>0,C1=0,D1>0),B1+D1,IF(AND(A1=0,B1>0,C1>0,D1=0),B1-C1,MIN(A1:D1)))))
Perfect! I was doing it the hard way, and figured out that you can only have 7 nested function levels, which wouldn't have worked because I needed 8. the "Min(range) fixed it.
And for that, you get a beer. Ty, WW.
go get the bird wrote:I'm trying to write a single function that does the following:
If A1>0, B1=0, C1>0, D1=0, then sum of A1 & B1, if not, 0.
If A1>0, B1=0, C1=0, D1>0, then A1-D1, if not, 0.
If A1=0, B1>0, C1=0, D1>0, then sum B1 & D1, if not, 0
If A1=0, B1>0, C1>0, D1=0, then B1-C1, if not, 0.
It's for an accounting spreadsheet where the balance sheet data(A1 and B1) and adjustments(C1 & D1) are combined to get the adjusted trial balance.
Any takers?
go get the bird wrote:whistlin_wings wrote:go get the bird wrote:I fiddled with the numbers a bit, got it working.
Next question: Lets say none of those criteria are met (there is only one cell in the range with data). How can you get it to display which ever cell in the range is >0 instead of displaying "0"? It only works now if there a x+y or x-y situation.
Instead of =IF(AND(A1>0,B1=0,C1>0,D1=0),A1+B1,IF(AND(A1>0,B1=0,C1=0,D1>0),A1-D1,IF(AND(A1=0,B1>0,C1=0,D1>0),B1+D1,IF(AND(A1=0,B1>0,C1>0,D1=0),B1-C1, 0))))
replace the 0 with "min" and select your range
=IF(AND(A1>0,B1=0,C1>0,D1=0),A1+B1,IF(AND(A1>0,B1=0,C1=0,D1>0),A1-D1,IF(AND(A1=0,B1>0,C1=0,D1>0),B1+D1,IF(AND(A1=0,B1>0,C1>0,D1=0),B1-C1,MIN(A1:D1)))))
Perfect! I was doing it the hard way, and figured out that you can only have 7 nested function levels, which wouldn't have worked because I needed 8. the "Min(range) fixed it.
And for that, you get a beer. Ty, WW.
OGblackcloud wrote:go get the bird wrote:I'm trying to write a single function that does the following:
If A1>0, B1=0, C1>0, D1=0, then sum of A1 & B1, if not, 0.
If A1>0, B1=0, C1=0, D1>0, then A1-D1, if not, 0.
If A1=0, B1>0, C1=0, D1>0, then sum B1 & D1, if not, 0
If A1=0, B1>0, C1>0, D1=0, then B1-C1, if not, 0.
It's for an accounting spreadsheet where the balance sheet data(A1 and B1) and adjustments(C1 & D1) are combined to get the adjusted trial balance.
Any takers?
Translated--- Does anyone want to do my home work so I can go out and play ?go get the bird wrote:whistlin_wings wrote:go get the bird wrote:I fiddled with the numbers a bit, got it working.
Next question: Lets say none of those criteria are met (there is only one cell in the range with data). How can you get it to display which ever cell in the range is >0 instead of displaying "0"? It only works now if there a x+y or x-y situation.
Instead of =IF(AND(A1>0,B1=0,C1>0,D1=0),A1+B1,IF(AND(A1>0,B1=0,C1=0,D1>0),A1-D1,IF(AND(A1=0,B1>0,C1=0,D1>0),B1+D1,IF(AND(A1=0,B1>0,C1>0,D1=0),B1-C1, 0))))
replace the 0 with "min" and select your range
=IF(AND(A1>0,B1=0,C1>0,D1=0),A1+B1,IF(AND(A1>0,B1=0,C1=0,D1>0),A1-D1,IF(AND(A1=0,B1>0,C1=0,D1>0),B1+D1,IF(AND(A1=0,B1>0,C1>0,D1=0),B1-C1,MIN(A1:D1)))))
Perfect! I was doing it the hard way, and figured out that you can only have 7 nested function levels, which wouldn't have worked because I needed 8. the "Min(range) fixed it.
And for that, you get a beer. Ty, WW.
Translated------ Hey thanks for doing my home work ! Wanna Juicy Juice, My Moms making cookies
OGblackcloud wrote:go get the bird wrote:I'm trying to write a single function that does the following:
If A1>0, B1=0, C1>0, D1=0, then sum of A1 & B1, if not, 0.
If A1>0, B1=0, C1=0, D1>0, then A1-D1, if not, 0.
If A1=0, B1>0, C1=0, D1>0, then sum B1 & D1, if not, 0
If A1=0, B1>0, C1>0, D1=0, then B1-C1, if not, 0.
It's for an accounting spreadsheet where the balance sheet data(A1 and B1) and adjustments(C1 & D1) are combined to get the adjusted trial balance.
Any takers?
Translated--- Does anyone want to do my home work so I can go out and play ?go get the bird wrote:whistlin_wings wrote:go get the bird wrote:I fiddled with the numbers a bit, got it working.
Next question: Lets say none of those criteria are met (there is only one cell in the range with data). How can you get it to display which ever cell in the range is >0 instead of displaying "0"? It only works now if there a x+y or x-y situation.
Instead of =IF(AND(A1>0,B1=0,C1>0,D1=0),A1+B1,IF(AND(A1>0,B1=0,C1=0,D1>0),A1-D1,IF(AND(A1=0,B1>0,C1=0,D1>0),B1+D1,IF(AND(A1=0,B1>0,C1>0,D1=0),B1-C1, 0))))
replace the 0 with "min" and select your range
=IF(AND(A1>0,B1=0,C1>0,D1=0),A1+B1,IF(AND(A1>0,B1=0,C1=0,D1>0),A1-D1,IF(AND(A1=0,B1>0,C1=0,D1>0),B1+D1,IF(AND(A1=0,B1>0,C1>0,D1=0),B1-C1,MIN(A1:D1)))))
Perfect! I was doing it the hard way, and figured out that you can only have 7 nested function levels, which wouldn't have worked because I needed 8. the "Min(range) fixed it.
And for that, you get a beer. Ty, WW.
Translated------ Hey thanks for doing my home work ! Wanna Juicy Juice, My Moms making cookies
Weg wrote:OGblackcloud wrote:go get the bird wrote:I'm trying to write a single function that does the following:
If A1>0, B1=0, C1>0, D1=0, then sum of A1 & B1, if not, 0.
If A1>0, B1=0, C1=0, D1>0, then A1-D1, if not, 0.
If A1=0, B1>0, C1=0, D1>0, then sum B1 & D1, if not, 0
If A1=0, B1>0, C1>0, D1=0, then B1-C1, if not, 0.
It's for an accounting spreadsheet where the balance sheet data(A1 and B1) and adjustments(C1 & D1) are combined to get the adjusted trial balance.
Any takers?
Translated--- Does anyone want to do my home work so I can go out and play ?go get the bird wrote:whistlin_wings wrote:go get the bird wrote:I fiddled with the numbers a bit, got it working.
Next question: Lets say none of those criteria are met (there is only one cell in the range with data). How can you get it to display which ever cell in the range is >0 instead of displaying "0"? It only works now if there a x+y or x-y situation.
Instead of =IF(AND(A1>0,B1=0,C1>0,D1=0),A1+B1,IF(AND(A1>0,B1=0,C1=0,D1>0),A1-D1,IF(AND(A1=0,B1>0,C1=0,D1>0),B1+D1,IF(AND(A1=0,B1>0,C1>0,D1=0),B1-C1, 0))))
replace the 0 with "min" and select your range
=IF(AND(A1>0,B1=0,C1>0,D1=0),A1+B1,IF(AND(A1>0,B1=0,C1=0,D1>0),A1-D1,IF(AND(A1=0,B1>0,C1=0,D1>0),B1+D1,IF(AND(A1=0,B1>0,C1>0,D1=0),B1-C1,MIN(A1:D1)))))
Perfect! I was doing it the hard way, and figured out that you can only have 7 nested function levels, which wouldn't have worked because I needed 8. the "Min(range) fixed it.
And for that, you get a beer. Ty, WW.
Translated------ Hey thanks for doing my home work ! Wanna Juicy Juice, My Moms making cookies
Did someone say something about some cookies?
MackieKnife wrote:The moral of the story is...I'm retarded.
Broken Paddle wrote:I do not really see this as cheating, he attempted to do his assignment, his instructor failed to give enough information to do the task. Did he learn something by asking here? YES! Every day, if I learn something new is a GOOD day.
Congrats. to those that helped the op, & congrats. to the op for learning something new. By the way, I learned something new today, THANX, this is a good day for me.
OGblackcloud wrote:Broken Paddle wrote:I do not really see this as cheating, he attempted to do his assignment, his instructor failed to give enough information to do the task. Did he learn something by asking here? YES! Every day, if I learn something new is a GOOD day.
Congrats. to those that helped the op, & congrats. to the op for learning something new. By the way, I learned something new today, THANX, this is a good day for me.
So in other words your a cheater too
Users browsing this forum: Dep6, Greenheadindy, OHIODUCKA5, rtaylor, SBE II, Sir Big Spur, Squoose and 31 guests