Formula help. Different result dependent on answer

M

martinco

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
 
P

Peo Sjoblom

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
 
B

Bernard Liengme

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
 
M

martinco

Simple - very clever - thank you!

Bernard Liengme said:
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
Click to expand...
 
Top