• Welcome to SVTPerformance!

Any Excel gurus in here?

Discussion in 'Road Side Pub' started by PC PaiN, Mar 28, 2010.

  1. PC PaiN

    PC PaiN Member Established Member

    Messages:
    512
    Joined:
    Mar 23, 2005
    Location:
    Waco, TX
    Working on a project for a class and I don't totally understand the hlookup function.

    This is what it tells me to do

    Use the HLookup function in cell C4 to display the minimum cash requirement. The function should look for the Risk Level code showing in cell C3 on the Portfolio worksheet in row 3 of the Investment Strategy worksheet. The minimum cash requirements are listed for each risk level in row 8.


    Now I thought I had a handle on it but I keep getting a REF error.
     
  2. Outlaw99

    Outlaw99 Join us. Moderator Premium Member

    Messages:
    16,834
    Joined:
    Oct 10, 2002
    Location:
    North Carolina
    click on the cell and you will see a box appear right next to it, click on it and select "help with error" and it should give you the formula to correct your problem.

    I use excel formulas everyday to figure my payroll. when ever something doesnt formulate right, i click that box and that helps.
     
  3. PC PaiN

    PC PaiN Member Established Member

    Messages:
    512
    Joined:
    Mar 23, 2005
    Location:
    Waco, TX
    yea was trying that and it didn't help. I searched the text book long enough and finally found where my error was.
     
  4. Defender

    Defender New Member Established Member

    Messages:
    15
    Joined:
    Jan 12, 2010
    Location:
    IL
  5. PC PaiN

    PC PaiN Member Established Member

    Messages:
    512
    Joined:
    Mar 23, 2005
    Location:
    Waco, TX
    Another one dealing with a nested if function

    If the dividend in cell G9 is greater than 0 and the current investment in cell F9 is greater than or equal to the original investment in cell E9, display the word HOLD

    If the current investment in cell F9 is less than the original investment in cell E9 or the current investment is less than the original investment multiplied by 1.035 then display the word SELL

    Otherwise display the word HOLD

    Can't figure out how to type out this formula
     
  6. piss&vinegar

    piss&vinegar Seek and Destroy Established Member

    Messages:
    935
    Joined:
    Feb 20, 2004
    Location:
    The World
    I have written many macros with it so if you need help with writing a macro to interact with a cell then let me know. Basically, a macro is a function your write that is not built into Excel itself and expands Excel usefulness exponentially to what you can do with it. A little off the topic of your question but thought it may be useful.
     
  7. PC PaiN

    PC PaiN Member Established Member

    Messages:
    512
    Joined:
    Mar 23, 2005
    Location:
    Waco, TX
    I basically just have no idea how to do this nested if function as stated by the problem. I think it's the and/or in the question that is messing me up
     
  8. txyaloo

    txyaloo New Member Established Member

    Messages:
    7,017
    Joined:
    Nov 28, 2004
    Location:
    Texas
    Without having your numbers to work with, I think this should do what the question is asking.

    =IF((AND(G9>0, F9>=E9)),HOLD,IF((OR(F9<E9,F9<E9*1.035)),SELL)
     
  9. PC PaiN

    PC PaiN Member Established Member

    Messages:
    512
    Joined:
    Mar 23, 2005
    Location:
    Waco, TX
    hrm excel ain't liking the formula, says it's missing paranthesis
     
  10. Mayo5

    Mayo5 New Member Established Member

    Messages:
    4,790
    Joined:
    Jul 28, 2005
    Location:
    Bruxelles.
    Then add them lol.
     
  11. txyaloo

    txyaloo New Member Established Member

    Messages:
    7,017
    Joined:
    Nov 28, 2004
    Location:
    Texas
    Try this then

    =IF((AND(G9>0, F9>=E9)),HOLD),IF((OR(F9<E9,F9<E9*1.035)),SELL)

    The syntax should be close. I may have dropped or added a parenthesis somewhere.
     
  12. PC PaiN

    PC PaiN Member Established Member

    Messages:
    512
    Joined:
    Mar 23, 2005
    Location:
    Waco, TX
    got it! thanks. just gotta do a present value function and im done
     
  13. txyaloo

    txyaloo New Member Established Member

    Messages:
    7,017
    Joined:
    Nov 28, 2004
    Location:
    Texas
    How far off was I? :lol:
     
  14. PC PaiN

    PC PaiN Member Established Member

    Messages:
    512
    Joined:
    Mar 23, 2005
    Location:
    Waco, TX
    actually not bad. I finally found an example of and/or on google and you were right there man. Thanks for taking the time to help.

    What's awesome is the assignment was due at 11:59, I finished at 12:30 and the system wouldn't let me submit. E-mailed it to the instructor, hopefully she takes it
     
  15. pho_phizzat

    pho_phizzat Dapper as **** Established Member

    Messages:
    9,957
    Joined:
    Oct 18, 2008
    Location:
    Around
    wow, i jsut realized i know nothing about excel
     

Share This Page