if value equals whole number then ...
 

I need to write a conditional statement that does the following:

If the result of <formula = a whole number, then <formula2, else <formula3

I have all the formulas working I just don't know how to writeup that first
condition, if the resulting value of the formula is a whole number then do
this, else that.

Pls help, thanks.

Answer: if value equals whole number then ...
 

To check if the result of a formula is a whole number:

1. Use the MOD function in Excel.
2. The MOD function returns the remainder after a number is divided by a divisor.
3. If the result of the MOD function is zero, then the number is a whole number.
4. Use the following formula:
   
   
   Code:

   ---

   =IF(MOD(<formula,1)=0,<formula2,<formula3)

   ---

5. Replace <formula with the formula you want to check if it's a whole number.
6. If the result of the MOD function is zero, then the formula is a whole number and <formula2 will be returned.
7. If the result of the MOD function is not zero, then the formula is not a whole number and <formula3 will be returned.

if value equals whole number then ...
 

Assuming <formula is in A1, then try this:

=IF(INT(A1)=A1,<formula2,<formula3))

INT returns the integer portion of A1. Another way would be:

=IF(MOD(A1,1)=0,<formula2,<formula3))

MOD returns the remainder after dividing A1 by 1.

Hope this helps.

Pete


On Mar 19, 4:40 pm, bd wrote:
I need to write a conditional statement that does the following:

If the result of <formula = a whole number, then <formula2, else <formula3

I have all the formulas working I just don't know how to writeup that first
condition, if the resulting value of the formula is a whole number then do
this, else that.

Pls help, thanks.

if value equals whole number then ...
 

=if(int(a1)=a1,....
or
=if(int(formula1)=formula1,formula2,formula3)


bd wrote:

I need to write a conditional statement that does the following:

If the result of <formula = a whole number, then <formula2, else <formula3

I have all the formulas working I just don't know how to writeup that first
condition, if the resulting value of the formula is a whole number then do
this, else that.

Pls help, thanks.

--

Dave Peterson

if value equals whole number then ...
 

Sorry,

my penultimate closing brackets should be in both formulae, i.e.:

=IF(INT(A1)=A1,<formula2,<formula3)
=IF(MOD(A1,1)=0,<formula2,<formula3)

Pete

On Mar 19, 4:47 pm, "Pete_UK" wrote:
Assuming <formula is in A1, then try this:

=IF(INT(A1)=A1,<formula2,<formula3))

INT returns the integer portion of A1. Another way would be:

=IF(MOD(A1,1)=0,<formula2,<formula3))

MOD returns the remainder after dividing A1 by 1.

Hope this helps.

Pete

On Mar 19, 4:40 pm, bd wrote:



I need to write a conditional statement that does the following:

If the result of <formula = a whole number, then <formula2, else <formula3

I have all the formulas working I just don't know how to writeup that first
condition, if the resulting value of the formula is a whole number then do
this, else that.

Pls help, thanks.- Hide quoted text -

- Show quoted text -