Results 1 to 3 of 3

Thread: IF

  1. #1
    Lounger
    Join Date
    Dec 2007
    Location
    Sacramento, California, USA
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Supplier #1 Supplier #2 Supplier #2

    Original Bid amount $100.00 $200.00 $300.00
    Original rank 1 2 3
    Certified Small Business? yes no no


    I need to find 5% of the lowest "original bid amount" from a non-certified Small business (where they've indicated "no").

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    The only solution to the problem you propose that I can come up with is a user defined function.

    See the attached workbook.

    I devised the function so that you pass it the column NUMBER of the column which determines certification and the certification status, e.g.
    =FivePct(4,"No")
    Where 4 is the column containing the certification status (D in this case) and "No" is the status.
    The function is hardwired to look for the bid 2 columns to the left of the status however you can easily add another argument to the function to accept another number indicating the location of the bid column (negative numbers indicate columns to the left and positive numbers indicate columns to the right). Taking this a step further you could add another argument to provide the percent to multiply the bid by if you wish.

    I hope this example helps.

    RG
    Attached Files Attached Files
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Does this do what you are after

    See Attached JPG

    [attachment=88658:MinIF.jpg]
    Attached Images Attached Images
    Andrew

Posting Permissions

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