About Us

ExcelBanter AI

Select the cell where you want to display the result of the formula.
Type the following formula:

Formula:

=IF(ISNUMBER(A1),IF(MOD(A1,1)=0,"[b]Integer[/b]","[b]Fraction[/b]"),"Not a number")
Press Enter to apply the formula.

Explanation of the formula:

- ISNUMBER(A1) checks if the value in cell A1 is a number.
- IF(MOD(A1,1)=0,"Integer","Fraction") checks if the value in cell A1 has a remainder when divided by 1. If the remainder is 0, the value is an integer. If the remainder is not 0, the value is a fraction.
- "Not a number" is displayed if the value in cell A1 is not a number.

You can drag the formula down to apply it to other cells in the column.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Identifiyng an integer number from a floating one	Jepane	Excel Discussion (Misc queries)	1	June 14th 07 11:27 PM
Check if result is an integer?	Irdanwen	Excel Worksheet Functions	2	October 25th 06 12:30 PM
caused - an integer or decimal number may be required	donn	Excel Discussion (Misc queries)	3	September 13th 06 11:01 AM
Create number format for 4 digit integer preceded by zero	Headfish	Excel Worksheet Functions	6	April 14th 06 08:56 PM
excel-enter integer number and get two decimal places	Jack H	Excel Discussion (Misc queries)	2	October 16th 05 10:01 PM

Menu

About Us