| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Getting text or numerical data from the formula
I have column O which is date format 00/00/0000, column Q which has either the word 'Date' or a numerical figure to 1 decimal place and column I which has a numerical figure to 1 decimal place. I need a formula in column S that looks at Q and if it shows date then it needs to return N/A in the S cell and if it has the numerical figure to 1 decimal place it needs to do the sum Q-I and give the result in the S cell. What should my formula be? Thanks in advance for any help. :-)
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need my formula to analyse numerical and text data | Excel Discussion (Misc queries) | |||
| Numerical data formula | Excel Worksheet Functions | |||
| Text and Numerical data in a Pivottable without summarising? | Excel Discussion (Misc queries) | |||
| Prevent non-numerical data (e.g. text) from plotting on a chart | Charts and Charting in Excel | |||
| Numerical Data vs Text | Excel Programming | |||
Threaded Mode
