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" wrote in message
...
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