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