Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to diferentiate integers with decimals in the IF formulas
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to diferentiate integers with decimals in the IF formulas
decimal seperator wrote:
Subject: how to diferentiate integers with decimals in the IF formulas I think your question is: how to recognize integral numbers. One answer: =IF(INT(A1) = A1, "integral number", "non-integral number") Caveat: If A1 is the result of a formula that involves non-integral numbers, the result might appear to be an integral number in the cell, but it really is not. In that case, it might be better to write: =IF(ABS(A1-INT(A1)) < 1E-6, "integral number", "non-integral number") where you might choose something other than 1E-6, depending on your tolerance or cell format. Alternatively, you might set the option Tools Options Calculation Percision as Displayed. But that might have unexpected consequences. Etiquette note: In the future, always include text in your message, even if it simply repeats the subject line. Some newsgroup readers do not show the entire subject line. Some newsgroup readers do not permit replies to postings with null text(!). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |