+ Reply to Thread
Results 1 to 4 of 4

Formula help. Different result dependent on answer

  1. #1
    martinco
    Guest

    Formula help. Different result dependent on answer

    Hi,

    I would like to write a formula which allows the user to put in the control
    data as either a % or £ sterling. For example:

    Rent £100 in year 1.

    For year 2 they either know the % increase or have a fixed figure, IE £200.

    Is there a formula which would identify whether they have entered a % or £
    figure?

    Thanks

    Ian

  2. #2
    Peo Sjoblom
    Guest

    Re: Formula help. Different result dependent on answer

    Not really unless they use text where you could look for the text strings,
    otherwise it is just numbers with different formats (displays), there is a
    function called cell("format") but that would not be very stable

    --
    Regards,

    Peo Sjoblom


    "martinco" <martinco@discussions.microsoft.com> wrote in message
    news:9191008F-3EF2-488E-AC67-C523580A6FE1@microsoft.com...
    > Hi,
    >
    > I would like to write a formula which allows the user to put in the
    > control
    > data as either a % or sterling. For example:
    >
    > Rent 100 in year 1.
    >
    > For year 2 they either know the % increase or have a fixed figure, IE
    > 200.
    >
    > Is there a formula which would identify whether they have entered a % or
    > figure?
    >
    > Thanks
    >
    > Ian




  3. #3
    Bernard Liengme
    Guest

    Re: Formula help. Different result dependent on answer

    The percentage values will (hopefully) be less than or equal to 1 (100%)
    The money value (hopefully) will be more than 1.00
    So =IF(B1<=1, "Percent","Loot")
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "martinco" <martinco@discussions.microsoft.com> wrote in message
    news:9191008F-3EF2-488E-AC67-C523580A6FE1@microsoft.com...
    > Hi,
    >
    > I would like to write a formula which allows the user to put in the
    > control
    > data as either a % or sterling. For example:
    >
    > Rent 100 in year 1.
    >
    > For year 2 they either know the % increase or have a fixed figure, IE
    > 200.
    >
    > Is there a formula which would identify whether they have entered a % or
    > figure?
    >
    > Thanks
    >
    > Ian




  4. #4
    martinco
    Guest

    Re: Formula help. Different result dependent on answer

    Simple - very clever - thank you!

    "Bernard Liengme" wrote:

    > The percentage values will (hopefully) be less than or equal to 1 (100%)
    > The money value (hopefully) will be more than £1.00
    > So =IF(B1<=1, "Percent","Loot")
    > best wishes
    > --
    > Bernard V Liengme
    > www.stfx.ca/people/bliengme
    > remove caps from email
    >
    > "martinco" <martinco@discussions.microsoft.com> wrote in message
    > news:9191008F-3EF2-488E-AC67-C523580A6FE1@microsoft.com...
    > > Hi,
    > >
    > > I would like to write a formula which allows the user to put in the
    > > control
    > > data as either a % or £ sterling. For example:
    > >
    > > Rent £100 in year 1.
    > >
    > > For year 2 they either know the % increase or have a fixed figure, IE
    > > £200.
    > >
    > > Is there a formula which would identify whether they have entered a % or £
    > > figure?
    > >
    > > Thanks
    > >
    > > Ian

    >
    >
    >


+ 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