Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Houston, TX
    Posts
    1

    Question Unanswered: Drop down menu & IF function

    I am trying to create a little spreadsheet that can be used as a quick quoting device. Everything has been pretty simple so far - [but] - I am trying to create a drop down menu with two options; one being YES and the second being NO. This item when the user selects YES will multiply a fixed amount by user inputed amount from previous two cells to create a price for an item.

    Example: There are four main columns; column A (ITEM), column B(QUANITY), column C (PRICE), and column D (TOTAL)

    This drop down menu will only be effected by ITEM A and ITEM B, lets say the user has established this quote will have 8 of Item A and 2 of Item B.

    I need to take that total of 10 multiply it by 20 to create 200 in column D.

    Any ideas?

  2. #2
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    James,

    Can You upload an example as I'm having difficulties to follow Your written words.

    Kind regards,
    Dennis
    Kind regards,
    Dennis

Posting Permissions

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