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. :-)
|
#2
|
|||
|
|||
Quote:
S. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 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 cell. What should my formula be? If the figures to 1 decimal place are already rounded, maybe this would work: =IF(ISNUMBER(Q1), Q1-I1, "N/A") Enter it it S1 and copy downward. If Q1 and I1 aren't rounded yet, apply the appropriate rounding function to them inside the formula. Apparently, column O plays no role in the calculation. |
Reply |
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 |