+ Reply to Thread
Results 1 to 3 of 3

Data Validation - Custom - Formula

  1. #1
    DYeomans
    Guest

    Data Validation - Custom - Formula

    I need to create a Formula for the following:

    =b10 to start formula

    The formula should determine that the value in cell B10 is less than or
    equal to 150% of the value in cell B9.

    Any help with this would be greatful, this is part of an homework assignment.

    Thanks


  2. #2
    Vasant Nanavati
    Guest

    Re: Data Validation - Custom - Formula

    =B10<=1.5*B9

    will return TRUE or FALSE.

    --

    Vasant

    "DYeomans" <DYeomans@discussions.microsoft.com> wrote in message
    news:05479F61-BBD7-4DCE-87C9-7A937E161070@microsoft.com...
    > I need to create a Formula for the following:
    >
    > =b10 to start formula
    >
    > The formula should determine that the value in cell B10 is less than or
    > equal to 150% of the value in cell B9.
    >
    > Any help with this would be greatful, this is part of an homework

    assignment.
    >
    > Thanks
    >




  3. #3
    DYeomans
    Guest

    RE: Data Validation - Custom - Formula

    Thank you! This had me for the last week!

    "DYeomans" wrote:

    > I need to create a Formula for the following:
    >
    > =b10 to start formula
    >
    > The formula should determine that the value in cell B10 is less than or
    > equal to 150% of the value in cell B9.
    >
    > Any help with this would be greatful, this is part of an homework assignment.
    >
    > Thanks
    >


+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1