Last visit was: 26 Apr 2026, 18:29 It is currently 26 Apr 2026, 18:29
Home
Messages
Tests
Schools
Events
Close
GMAT Club Daily Prep
Thank you for using the timer - this advanced tool can estimate your performance and suggest more practice questions. We have subscribed you to Daily Prep Questions via email.

Customized
for You

we will pick new questions that match your level based on your Timer History

Track
Your Progress

every week, we’ll send you an estimated GMAT score based on your performance

Practice
Pays

we will pick new questions that match your level based on your Timer History
Not interested in getting valuable practice questions and articles delivered to your email? No problem, unsubscribe here.
Go to My Error Log Learn more
Close
Request Expert Reply
Confirm Cancel
avatar
Bosley
avatar
Joined: 25 Dec 2007
Last visit: 27 Sep 2023
Posts: 17
Posts: 17
Kudos: 0
Excel question 28 Mar 2008, 08:51
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Id figure id post this question here.

Does anybody know how to refer to all previous columns?

For instance, say im in (F16), I want that cell to return 0 if any other previous column
(A16:E16) is greater than 0.

Thanks!
User avatar
Irishfan
User avatar
Current Student
Joined: 23 Dec 2007
Last visit: 15 Apr 2010
Posts: 138
Own Kudos:
18
Posts: 138
Kudos: 18
Excel question 28 Mar 2008, 09:24
Kudos
Add Kudos
Bookmarks
Bookmark this Post
=if(sum(a16:e16)>0,0,**value you want if the sum is less than zero**)
avatar
Bosley
avatar
Joined: 25 Dec 2007
Last visit: 27 Sep 2023
Posts: 17
Posts: 17
Kudos: 0
Excel question 28 Mar 2008, 09:26
Kudos
Add Kudos
Bookmarks
Bookmark this Post
cool thanks
User avatar
aaudetat
User avatar
Joined: 01 Nov 2006
Last visit: 10 Jan 2016
Posts: 1,854
Own Kudos:
233
Given Kudos: 2
Concentration: Social Enterprise
Schools:The Duke MBA, Class of 2009
Posts: 1,854
Kudos: 233
Excel question 29 Mar 2008, 18:06
Kudos
Add Kudos
Bookmarks
Bookmark this Post
i'm taking an entire class on getting excel to do stuff like that - it's a bit of a pain, but such a good learning experience. Soon, my i-banker friends will have nothing on my excel skills! I am currently the proud parent of a very smoking pivot table.
User avatar
obeny81
User avatar
Joined: 05 Oct 2006
Last visit: 27 Apr 2009
Posts: 43
Own Kudos:
4
Posts: 43
Kudos: 4
Excel question 29 Mar 2008, 18:45
Kudos
Add Kudos
Bookmarks
Bookmark this Post
a course in Excel definitely pays dividends...
avatar
girl10021
avatar
Joined: 05 Dec 2006
Last visit: 13 Oct 2008
Posts: 16
Posts: 16
Kudos: 0
Excel question 30 Mar 2008, 02:37
Kudos
Add Kudos
Bookmarks
Bookmark this Post
This wasn't the question, but my inner excel nerd can't help it.... :)

If the cells contained text and not numbers and you wanted to see if any of the cells were nonblank, you could use the following (just fyi in case it came up):

if(or(a1<>"",b1<>""c1<>"",d1<>"",e1<>"")),"nonblank","blank") or whatever other description you wanted to replace...
User avatar
djhouse81
User avatar
Current Student
Joined: 30 May 2007
Last visit: 13 Aug 2009
Posts: 485
Own Kudos:
72
Posts: 485
Kudos: 72
Excel question 31 Mar 2008, 11:46
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Learn to use shortcut keys for Excel. Don't be addicted to your mouse, it will save you a ton of time!
User avatar
forcefeed
User avatar
Joined: 29 Dec 2006
Last visit: 15 Aug 2014
Posts: 214
Own Kudos:
22
Posts: 214
Kudos: 22
Excel question 01 Apr 2008, 20:41
Kudos
Add Kudos
Bookmarks
Bookmark this Post
aaudetat
i'm taking an entire class on getting excel to do stuff like that - it's a bit of a pain, but such a good learning experience. Soon, my i-banker friends will have nothing on my excel skills! I am currently the proud parent of a very smoking pivot table.
Show more

Is this a class at Fuqua or an online class? I want to work on this before I get to b-school and will probably just grab a book off amazon. The two books I am currently thinking about are "Principles of Finance with Excel" by Simon Benninga and "Business Analysis with Microsoft Excel" by Conrad Carlberg. Does anyone have any experience with these books, or others that they recommend?
User avatar
aaudetat
User avatar
Joined: 01 Nov 2006
Last visit: 10 Jan 2016
Posts: 1,854
Own Kudos:
233
Given Kudos: 2
Concentration: Social Enterprise
Schools:The Duke MBA, Class of 2009
Posts: 1,854
Kudos: 233
Excel question 01 Apr 2008, 21:10
Kudos
Add Kudos
Bookmarks
Bookmark this Post
forcefeed
aaudetat
i'm taking an entire class on getting excel to do stuff like that - it's a bit of a pain, but such a good learning experience. Soon, my i-banker friends will have nothing on my excel skills! I am currently the proud parent of a very smoking pivot table.

Is this a class at Fuqua or an online class? I want to work on this before I get to b-school and will probably just grab a book off amazon. The two books I am currently thinking about are "Principles of Finance with Excel" by Simon Benninga and "Business Analysis with Microsoft Excel" by Conrad Carlberg. Does anyone have any experience with these books, or others that they recommend?
Show more
it's a class at fuqua. our instructor has a list of her favorite excel books - i will check it out and post here.
avatar
Bosley
avatar
Joined: 25 Dec 2007
Last visit: 27 Sep 2023
Posts: 17
Posts: 17
Kudos: 0
Excel question 03 Apr 2008, 08:19
Kudos
Add Kudos
Bookmarks
Bookmark this Post
We have a 'Training the Street' seminar this weekend. A 2 day 16 hour intensive modeling
workshop. I'm looking forward to it, but at the same time, somewhat fearful :)

Though it seems every job I've interviewed for be it strategy, finance, or marketing i've
been asked about my excel modeling experience, which to date is minimal.
User avatar
aaudetat
User avatar
Joined: 01 Nov 2006
Last visit: 10 Jan 2016
Posts: 1,854
Own Kudos:
233
Given Kudos: 2
Concentration: Social Enterprise
Schools:The Duke MBA, Class of 2009
Posts: 1,854
Kudos: 233
Excel question 06 Apr 2008, 16:19
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Does anyone know VBA for Excel?

I'm supposed to make a VBA function of my choosing. Here's what I've got:

(column A)
Euros
.5
78
234
etc

(Column B)
Dollars
this is where I put my formula, which will refer to my function.

I just don't really get how the VBA view/function and the excel formula relate.

Can anyone help? (Please don't just post an answer, but explain what's going on.)

thanks
aau