HOW DO I SELECT ROUND NUMBERS ONLY IN EXCEL SPREADSHEET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to write a formula where if a cell contains a whole number a certain
value will be returned (true) but if its not a whole number (false) another
value will be returned. Thanks for any help
 
Hi

One way
=IF(INT(A1)=A1,1,2)
Replace 1 and 2 with your values or cell references.

Regards

Roger Govier
 
Hi, Thanks very much for that - fantastic

Roger Govier said:
Hi

One way
=IF(INT(A1)=A1,1,2)
Replace 1 and 2 with your values or cell references.

Regards

Roger Govier
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup returning wrong results 0
Rounding Negative Numbers to Zero 4
Alternate Rounding Up & Down of .50 in a column 5
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
cell value functioning as whole number in formulas 4
Round Function 5
Red cell for negative numbers in Excel 1
How do I have a cell value define a dynamic named range? 15

Back
Top