Selecting "odd" and "even" numbers

  • Thread starter Thread starter Rocketeer
  • Start date Start date
R

Rocketeer

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
 
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
 
Not sure what result you're looking for but this formula will sum only the
whole numbers in the range:

=SUMPRODUCT(--(MOD(A1:A5,1)=0),A1:A5)

And this formula will sum only numbers that have a decimal:

=SUMPRODUCT(--(MOD(A1:A5,1)>0),A1:A5)
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top