How do I differentiate between integer and floating point numbers in a double array?

7 views (last 30 days)
My requirement is to import data from Excel which has both integer and floating point numbers. For example, 1 and 2.5 I want to differentiate between them. But the Excel import coverts all numeric data into 'double' which is floating point by default.
Any help in this regard is appreciated! Thanks!

Accepted Answer

José-Luis
José-Luis on 15 Jan 2014
is_integer = your_data == floor(your_data);
  2 Comments
Shubha
Shubha on 15 Jan 2014
isinteger(floor(2.3)) also returns a 0. So how is it possible to differentiate integers from floating point numbers then?
Shubha
Shubha on 15 Jan 2014
Oh yeah now I get it if (my_data==floor(my_data)) 'Its an integer' else 'Its a floating point value' end This works well! Thanks for the help!

Sign in to comment.

More Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!