IF Formula Query for Integers and Non-Integers

**mrvp** · 03-09-2012, 06:42 PM

Hi,

I have a worksheet for working out percentages for College Basketball spreads in relation to handicaps and in short I am looking to minimise the amount I need to do manually.

In short all I am struggling to make work is how it determines the percentages for calculating a tie.

If the Handicap equals a non-integer (e.g. 1.5 - it's usually a half of something) the percentage = 0%.

I have the handicap in cell A8. What I am struggling to think of is a suitable IF criteria to force this. The cell for the tie% is B11 and the Game Power Rating difference needs to be positive which I have forced in C8.

If the handicap in A8 is an integer the formula I will add is:

NORMDIST((A8+0.5),C8,10,TRUE)-(NORMDIST((A8-0.5),C8,10,TRUE))

I've probably missed a bracket somewhere above but am confident in the formula.

I am thinking the easiest way of doing this is through an IF function but cannot think of a suitable IF criteria to sort determine an integer from a non-integer.

The rest of the sheet I have reduced down to the point where you just need to add team names, ratings and a handicap.

I'd be grateful for any advice anyone can offer (and am happy to attach the sheet).

Thanks in advance,

**icestationzbra** · 03-09-2012, 06:47 PM

if you are looking to figure out whether a number is integer or not, you could use something as simple as this:

=IF(A1-INT(A1)<>0,"not","int")

with your number in A1.

**DGagnon** · 03-09-2012, 06:51 PM

im not sure i understand the full desired output, but here is an if statement that will help you.

=IF(MOD(A8,1)>0,WHAT TO DO IF NON-INTEGER,WHAT TO DO IF INTEGER)

**mrvp** · 03-09-2012, 07:35 PM

Thanks DGagnon - I tried this solution first and it works absolutely fine (except it revealed an error in another formula when dealing with handicaps that are integers as I now have something that should add up to 100% adding up to somewhere between 100 and 110%). A little bit more work to do for me yet.

Many thanks.