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

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

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

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
>
>
>