+ Reply to Thread
Results 1 to 4 of 4

What function do i use for these questions?

  1. 12-14-2011, 09:15 PM #1
    m00jo
    m00jo is offline
    Registered User
    Join Date
    12-14-2011
    Location
    Ontario
    MS-Off Ver
    Excel 2010
    Posts
    2

    What function do i use for these questions?

    I'm doing a review and I must have missed the classes for these functions, can someone help me out?
    http://i.imgur.com/mZT8z.png
    Attached Files Attached Files
    Last edited by m00jo; 12-14-2011 at 09:21 PM.
    Reply With QuoteRegister To Reply
  2. 12-14-2011, 10:15 PM #2
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: What function do i use for these questions?

    Hello

    Welcome to the forum...

    Ok Let's review

    Ok how about you use lookup == lookup(no of copies made, no of copies , price per copy) this will give you the amount per copy

    try it first then what is the next step?
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  3. 12-14-2011, 11:25 PM #3
    m00jo
    m00jo is offline
    Registered User
    Join Date
    12-14-2011
    Location
    Ontario
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: What function do i use for these questions?

    =LOOKUP(A13,A2:A7,B2:B7)*A13

    Thanks! I pretty much realize how to do it I just needed to remember the function.
    Reply With QuoteRegister To Reply
  4. 12-14-2011, 11:27 PM #4
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: What function do i use for these questions?

    Right Hope you got high grades, regards..
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1