Try this

=If(Mod(A1,1)=0,A1*Price,A1*Price + Split Charge)

Mod takes the remainder of dividing A1 by 1. So if its 1.5 the answer will
be .5

"Rocketeer" wrote:

Hi!

I have data in the following format in say column A:

A1: 1.0
A2: 1.5
A3: 2.0
A4: 2.5
A5: 3.0

etc. I'm trying to find out if it is possible with an IF statement of similar
to do a calculation if the data is 1.0, 2.0 or 3.0. That is, I don't want to
do a calculation if the data is 1.5, 2.5 etc. I tried the ISEVEN and
ROUND functions without any luck.

The problem shall solve price differences when you don't have even number
of say doughnuts. If you sell 2 doughnuts you have the price for just two
doughnuts. But if someone wants 2.5 doughnuts the price shall be calculated
for 2.5 doughnuts and an additional split charge as well.

2 doughnuts - price = A3*price per doughnuts
2.5 doughnuts - price = A4*price per doughnuts + split charge

Kind Regards