if statement
 

is there a way to formulate the following.
IF A2 = whole number then enter 0 if A2 contains a decimal than enter
content of B4.

whole number = any number without a decimal ie 1, 4 ,6 ,10, 15, ect

Decimal = any number with decimal ie 1.11, 4.32, 5.5, 10.6, 33.33, ect

if statement
 

On Thu, 30 Jul 2009 12:14:01 -0700, ironworker
wrote:

is there a way to formulate the following.
IF A2 = whole number then enter 0 if A2 contains a decimal than enter
content of B4.

whole number = any number without a decimal ie 1, 4 ,6 ,10, 15, ect

Decimal = any number with decimal ie 1.11, 4.32, 5.5, 10.6, 33.33, ect



Try this formula:

=IF(A2=INT(A2),0,B4)

Hope this helps / Lars-Åke

if statement
 

=IF(MOD(A2,1)=0,0,B4)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ironworker" wrote in message
...
is there a way to formulate the following.
IF A2 = whole number then enter 0 if A2 contains a decimal than enter
content of B4.

whole number = any number without a decimal ie 1, 4 ,6 ,10, 15, ect

Decimal = any number with decimal ie 1.11, 4.32, 5.5, 10.6, 33.33, ect

if statement
 

thank you I was able to uses nieks for my situation

"Niek Otten" wrote:

=IF(MOD(A2,1)=0,0,B4)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ironworker" wrote in message
...
is there a way to formulate the following.
IF A2 = whole number then enter 0 if A2 contains a decimal than enter
content of B4.

whole number = any number without a decimal ie 1, 4 ,6 ,10, 15, ect

Decimal = any number with decimal ie 1.11, 4.32, 5.5, 10.6, 33.33, ect