Help With Microsoft Excel

[MIKolbe]

=VLOOKUP(B1534,[processes_per_item.xls]Sheet1!$B:$C,2,0)

BOO-YAH!!!!!

[MIKolbe]

=IF(H5="1 AA not inc",0.06,IF(H5="1 AAA not inc",0.08,IF(H5="2 AAA not inc",0.16,0)))

YEAH!!!!!!!!!!!1

[rkwright]

I have an excel question thats been bugging me.

Say I have two sheets. Sheet 1 is where all my formulas are and sheet 2 is just the data.

In one cell in sheet 1 the formula is A1+Sheet2B3. The next cell below it should be A1+Sheet2C3, and then A1+Sheet2D3, and so on - but when I click and drag the black box it autofills it as A1+Sheet2B4, A1+Sheet2B5, ect. Instead of going to the next row I want it to auto fill to the next column.

[MIKolbe]

the easier solution is to drag in the direction of the data

also, make sure A1 is $a$1

[rkwright]

[quote name='MIkolbe' date='12 December 2009 - 12:48 PM' timestamp='1260640082' post='2019167']
the easier solution is to drag in the direction of the data

also, make sure A1 is $a$1
[/quote]

Yea all the formatting is correct.

Is that really the only thing though? Because the data has to go in one way, and the output is the formulas in a different format

[MIKolbe]

well yes... the cell formulas are relative.

I am sure there are work arounds, but they would basically boil down to reformatting the data.

[N/A Gone]

[quote name='mommas_boy' date='11 December 2009 - 04:18 PM' timestamp='1260566338' post='2018638']
Assuming that debits are denoted from credits by a negative sign ... you want credits/debits in column A, and running total in column B:

[code]
A B
----- -----
1: 1000 1000
2: -100 900
3: -24 876
4: 500 1376
[/code]

In cell B1, input:

[code]
=A1
[/code]

In cell B2, input:

[code]
=B1+A2
[/code]

And then drag, or double click.

The only way that this works is if you denote debits with a negative sign so that it "adds" a negative.
[/quote]


Thank you,

Not to be a burden, it will not let me drag or double click (well, I can but nothing happens) I am using either the Mac numbers version or a mobile excel. Could that be the issue? I was able to use the equation cell by cell, but not for the whole column.

[mommas_boy]

[quote name='Revprodeji' date='12 December 2009 - 09:32 PM' timestamp='1260671526' post='2019471']
Thank you,

Not to be a burden, it will not let me drag or double click (well, I can but nothing happens) I am using either the Mac numbers version or a mobile excel. Could that be the issue? I was able to use the equation cell by cell, but not for the whole column.
[/quote]

Hmm. That's odd. I'm not certain about the mobile version. But for the Mac, are you sure that you are clicking on the itty bitty black square in the bottom-right corner of the cell? You can't just click the cell. You have to click the little black box (not the black outline of the cell) in the corner. Looks like this:

[img]http://homepage.cs.uri.edu/tutorials/csc101/pc/excel97/images/excel12.jpg[/img]

It's pretty standard across all spreadsheet programs; eg. I use OpenOffice, and sometimes Google Docs, and it's there, too.

[loveletslive]

[quote name='MIkolbe' date='12 December 2009 - 11:55 AM' timestamp='1260636959' post='2019124']
=IF(C1540<20.01,"300+",IF(C1540<35.01,"175+",IF(C1540<50.01,"150+",IF(C1540<80.01,"75+",IF(C1540<115.01,"50+",IF(C1540<200.01,"35+",IF(C1540<500.01,"25+","15+")))))))


THAT'S WHAT I'M TALKIN' 'BOUT!!!!!!!
[/quote]

oh God, NOOOOOOO!!!

i just took a 2 hour lab practical for this crazy business in computers class. this one was mainly manual simulation, @risk simulation, stattools data analysis, and filtering tables.

i never want to look at excel again unless i can do everything with =sum or something equally easy, haha. also can i just say nested IF statements with vlookups and hlookups are SATAN.

Edited December 13, 2009 by loveletslive

[N/A Gone]

Momma's boy, I got it it work, but now the total is in every box the whole way down. is there anyway that the box can stay blank until I have a number in the same row?

[N/A Gone]

nvm, figured it out. Thank you so much.

[ReinnieR]

in office 2010 there's a new tab button next to the existing tabs

[ReinnieR]

also office 2010 supports OOo formats i never played with office 2007 i don't really know if that's something new or something that 07 had

[mommas_boy]

[quote name='Revprodeji' date='15 December 2009 - 11:23 AM' timestamp='1260894212' post='2020981']
Momma's boy, I got it it work, but now the total is in every box the whole way down. is there anyway that the box can stay blank until I have a number in the same row?
[/quote]


[quote name='Revprodeji' date='15 December 2009 - 01:04 PM' timestamp='1260900255' post='2021059']
nvm, figured it out. Thank you so much.
[/quote]

Not sure how you did it, but the following may be a more elegant solution. Into cell B2, input:

[code]
=IF(A2>0,B1+A2,0)
[/code]

Then drag all the way down.