Find all School-related info fast with the new School-Specific MBA Forum

It is currently 20 Oct 2014, 10:46

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.

Events & Promotions

Events & Promotions in June
Open Detailed Calendar

Excel question

  Question banks Downloads My Bookmarks Reviews Important topics  
Author Message
Intern
Intern
avatar
Joined: 25 Dec 2007
Posts: 17
Followers: 0

Kudos [?]: 0 [0], given: 0

Excel question [#permalink] New post 28 Mar 2008, 07:51
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!
Current Student
User avatar
Joined: 23 Dec 2007
Posts: 138
Followers: 1

Kudos [?]: 12 [0], given: 0

Re: Excel question [#permalink] New post 28 Mar 2008, 08:24
=if(sum(a16:e16)>0,0,**value you want if the sum is less than zero**)
Intern
Intern
avatar
Joined: 25 Dec 2007
Posts: 17
Followers: 0

Kudos [?]: 0 [0], given: 0

Re: Excel question [#permalink] New post 28 Mar 2008, 08:26
cool thanks
SVP
SVP
User avatar
Joined: 01 Nov 2006
Posts: 1855
Schools: The Duke MBA, Class of 2009
Followers: 16

Kudos [?]: 180 [0], given: 2

Re: Excel question [#permalink] New post 29 Mar 2008, 17:06
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.
Intern
Intern
User avatar
Joined: 05 Oct 2006
Posts: 43
Followers: 0

Kudos [?]: 4 [0], given: 0

Re: Excel question [#permalink] New post 29 Mar 2008, 17:45
a course in Excel definitely pays dividends...
Intern
Intern
avatar
Joined: 05 Dec 2006
Posts: 16
Followers: 1

Kudos [?]: 0 [0], given: 0

Re: Excel question [#permalink] New post 30 Mar 2008, 01:37
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...
Senior Manager
Senior Manager
User avatar
Joined: 30 May 2007
Posts: 496
Followers: 7

Kudos [?]: 69 [0], given: 0

Re: Excel question [#permalink] New post 31 Mar 2008, 10:46
Learn to use shortcut keys for Excel. Don't be addicted to your mouse, it will save you a ton of time!
Manager
Manager
User avatar
Joined: 29 Dec 2006
Posts: 214
Followers: 5

Kudos [?]: 21 [0], given: 0

Re: Excel question [#permalink] New post 01 Apr 2008, 19:41
aaudetat wrote:
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?
SVP
SVP
User avatar
Joined: 01 Nov 2006
Posts: 1855
Schools: The Duke MBA, Class of 2009
Followers: 16

Kudos [?]: 180 [0], given: 2

Re: Excel question [#permalink] New post 01 Apr 2008, 20:10
forcefeed wrote:
aaudetat wrote:
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?

it's a class at fuqua. our instructor has a list of her favorite excel books - i will check it out and post here.
Intern
Intern
avatar
Joined: 25 Dec 2007
Posts: 17
Followers: 0

Kudos [?]: 0 [0], given: 0

Re: Excel question [#permalink] New post 03 Apr 2008, 07:19
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.
SVP
SVP
User avatar
Joined: 01 Nov 2006
Posts: 1855
Schools: The Duke MBA, Class of 2009
Followers: 16

Kudos [?]: 180 [0], given: 2

Re: Excel question [#permalink] New post 06 Apr 2008, 15:19
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
Re: Excel question   [#permalink] 06 Apr 2008, 15:19
    Similar topics Author Replies Last post
Similar
Topics:
2 OG Verbal Review 2nd Edition-All Sentence Correction Questions Excel sa2222 0 02 Sep 2014, 06:30
1 Experts publish their posts in the topic Asking Excellent Questions mikemcgarry 0 30 Aug 2014, 12:16
excel question RoyHalladay 0 10 Aug 2012, 17:34
2 Experts publish their posts in the topic OG12 Question type in Excel... humphy 9 18 Apr 2011, 21:22
Excel Tutorial lanter1 10 02 Jul 2008, 13:02
Display posts from previous: Sort by

Excel question

  Question banks Downloads My Bookmarks Reviews Important topics  

Moderator: threestripes



GMAT Club MBA Forum Home| About| Privacy Policy| Terms and Conditions| GMAT Club Rules| Contact| Sitemap

Powered by phpBB © phpBB Group and phpBB SEO

Kindly note that the GMAT® test is a registered trademark of the Graduate Management Admission Council®, and this site has neither been reviewed nor endorsed by GMAC®.