Excel 2007 : whole and not whole number in if statement

**darkhangelsk** · 01-06-2011, 11:11 AM

Hi,

Attached is my sample file. I just can't understand why IF statement can't identify the whole number and not while using the MOD formula.

Please help me on this.

Thanks!

**NBVC** · 01-06-2011, 11:16 AM

With this part:

=IF(MOD(E12,1)

you are saying if MOD(E12) is a number other than 0, than evaluate the TRUE part of the IF... so the MOD(E12,1) is the MOD(18.75,1) which is .75, which is not 0, so TRUE, so then check if B12 (45) is less than 60, which it is, therefore return E12

**Marcol** · 01-06-2011, 11:17 AM

Not sure of your intentions, but try this

Please Login or Register  to view this content.

Hope this helps

**darkhangelsk** · 01-06-2011, 11:24 AM

ooooh Marcol, just forgot the ZERO! Thanks, both of you! amazing forum, never fails.

**darkhangelsk** · 01-06-2011, 11:42 AM

WAITTT!!! I saw another problem. Goshh... I attached it, can't believe i'm still lock on this IF then else statement.

**NBVC** · 01-06-2011, 11:46 AM

That one is due to precision, probably based on the formula you have in column B using non-whole numbers..

Try this:

=IF(MOD(ROUND(E6,2),1)=0,IF(B6<=60,E6,G6),F6)

copied down, assuming accuracy of 2 decimal places suffices your needs.

**darkhangelsk** · 01-06-2011, 11:57 AM

Originally Posted by NBVC

That one is due to precision, probably based on the formula you have in column B using non-whole numbers..

Try this:

=IF(MOD(ROUND(E6,2),1)=0,IF(B6<=60,E6,G6),F6)

copied down, assuming accuracy of 2 decimal places suffices your needs.

Wow!!! I don't know how did you understand my messy work. I tried several sample and it works. Thank you so much!