| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula help. Different result dependent on answer
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying result of formula into another worksheet??? | Excel Discussion (Misc queries) | |||
| Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
Threaded Mode
