Whole numbers and remainders

  • Thread starter Thread starter tmcgrew1
  • Start date Start date
T

tmcgrew1

I want to use the result of dividing two numbers in Excel to do other
operations in an 'If Then' statement. If the number is a whole
number, do one thing otherwise something else. In other words if the
remainder is zero do this, otherwise this. How can I do that? Is an
'If Then' statement the right approach?
 

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

How to get different base systems so letters will show up like hex system tia sal2 1
how to display answer as whole number and remainder 3
Identify Whole Number 5
formating to show quotient and remainder 2
Custom Number Format for text 8
multiple functions on one cell ? 6
How can I tell if a number is a whole number? 2
Rolling over a Remainder 2

Back
Top