Try something like:

Any number of doughnuts

price = A3*price per doughnuts + (split charge *(MOD(A3),1<0)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Rocketeer" wrote in message
...
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