A maffs conundrum

OK, something is priced at £1.04 each and using a volume
discount formula and the price comes to £75.83 for 100
Price each comes to £0.7583
obviously this would show as £0.76

Now if you want 100 of these, what do you do?

100 * 0.76 = 76.00 + 15.2 VAT = £91.20

or

£75.83 + £15.17 VAT = £91.00

????


--
Rob_P
UKRM(at)indqualtec.co.uk
uppercase(d) BBIWYMC#1 BOG#11? MRO#31 IBCDBBB#1(kotl)
FJ1200, CCM130 Benelli Cabriolet (gone)
Looks like Rab C Nesbit.

 

What, exactly, is your problem?

 

Don't round up or down until the total, you buffoon.

 

OMG! Do you really think he was being _that_ thick? I assumed there
must be something else he was wanting help on.

I should learn not to overestimate some people.

 

Ginge spoke:

I am not rounding until the total - the total is correct at
75.83, it is the fact that the Price Each is shown formatted
to 2 dp, hence 76p


--
Rob_P
UKRM(at)indqualtec.co.uk
uppercase(d) BBIWYMC#1 BOG#11? MRO#31 IBCDBBB#1(kotl)
FJ1200, CCM130 Benelli Cabriolet (gone)
Looks like Rab C Nesbit.

 

Are you working with Excel? - because, even if you ask it to display
figures to 2 decimal places, it will still work with the 'full' figure
in calculations.

 

Exactly. You're rounding the price per item, from £0.7583 each to £0.7600
each

 

a) Purple
b) Michael
c) Fiji
d) Grapefruit
d) All of the above.

 

Show the price as full, and apply the discount separately.

=((Price * Quantity) - ((Price x Quantity) * Quantity related
discount%) * VAT%)

Simples

 

C) Fiji.

Defintely Fiji as if you're not sure of the answer it's always Fiji.

 

Ginge spoke:

Would that it were so!

It isn't!

Discounts, for example, hare subject to 5 possible variations of
calculation, some are 1 line at a time, some are based on total
order/quote value, some add a surcharge for Ebay, some use half
discounts, some use a simple % discount.

It's not only the financial services/insurance people who
over-complicate things - some SME's are dab-hands at
de-simplifying.

--
Rob_P
UKRM(at)indqualtec.co.uk
uppercase(d) BBIWYMC#1 BOG#11? MRO#31 IBCDBBB#1(kotl)
FJ1200, CCM130 Benelli Cabriolet (gone)
Looks like Rab C Nesbit.

 

SteveH spoke:

No, other than to shove numbers into excel to confirm the code is
calculating things correctly.


--
Rob_P
UKRM(at)indqualtec.co.uk
uppercase(d) BBIWYMC#1 BOG#11? MRO#31 IBCDBBB#1(kotl)
FJ1200, CCM130 Benelli Cabriolet (gone)
Looks like Rab C Nesbit.

 

It is.

YT, TTTTTTT, C.

 

Ah, so that's why I never made it past the initial Mastermind
application tests.