If statement problem

[beamer]

Hello all:

Don't know if this is possible, but....

I am looking to have a cell either output a number as a percentage or whole number (currency).

that said if I create a dropdown box that has an if statement tied to it (i.e:=IF(A1="Percentage",...... or A1="Currency"....) how would I make it so that cell A3 is either percentage or currency?

Moreover, if the user opts for either percentage or currency, am I correct by creating 3 cells to perform task (i.e A1 is data entered, A2 is if statement, A3 is conditional answer cell)?

[FDibbins]

to the best of my knowledge, a cell cannot have to different numeric formats. perhaps consider putting the answers into 2 different cells

[BB1972]

beamer,

Can you upload a small example file with some of the data you're dealing with, indicating what your A3 is a percentage of? I think we can be a little creative and come up with a solution for you. On a Champions League night and all!