How can I conditional format to show either a percentage or a whol

[Simon]

How do I get an IF function to return a percentage when applicable?

--------------------------------------------------------------------------------

Here is the problem:

I am using a Concatenated Lookup function in conjunction with a drop down
box. There are three options in the drop down - two are numbers, one is a
percentage.

I need to get the lookup funtion combined with an IF function to say when I
choose one of the two number options return a number, when I choose the
percentage option, return a percentage.

Any ideas? I looked for a PERCENT funtion but there isn't one!

This one has me stumped.

Thanks

Simon

[Bob Phillips]

Simon,

the problem is that a percentage is a number, it is just shown as a
percentage. Any other characteristics that differentiate, e.g. the 'numbers'
are always greater than 1 but the percentage is always < 100%?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Simon" <[email protected]> wrote in message
news:[email protected]...
> How do I get an IF function to return a percentage when applicable?
>
> --------------------------------------------------------------------------
------
>
> Here is the problem:
>
> I am using a Concatenated Lookup function in conjunction with a drop down
> box. There are three options in the drop down - two are numbers, one is a
> percentage.
>
> I need to get the lookup funtion combined with an IF function to say when
I
> choose one of the two number options return a number, when I choose the
> percentage option, return a percentage.
>
> Any ideas? I looked for a PERCENT funtion but there isn't one!
>
> This one has me stumped.
>
> Thanks
>
> Simon
>

[Jonathan May]

Perhaps I can jump in with my requirement...

The number format depends on the column you're looking up.

I have a similar problem where I'm bringing back monetary values and/or integers.

I don't think there's a solution other than using Macros rather than a conditional formatting. (I might be wrong...)

Jonathan