Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Hi,

I have a formula below which is giving me an Err: 502 on Calc 3.4.5 when I try and calculate a currency total using a sliding scale.

=SUM((((IF(b6>c2,d2,0),(IF(b6-c2)>c3,d3,0),(IF(b6-c2-c3)>c4,sum((b6-c2)-c3)*b4,0))))

Each IF statement outs only a single answer and all I want to do is SUM the 'IF' answers

I have Googled and tried the above IF formula in a few ways, but despite giving me a correct answer after two IF's, adding the third IF gives me a 502 error which wrecks the entire formula i.e. removing 3rd IF gives no answer. Pasting the above formula back into Calc turns many of the commas(,) into a tilde (~).

My data is so:

Units to convert to currency value(B6): 1349.31
First avail 150 units(C2) are $1.1311 each
The next avail 450 units(C3) are $1.811 each
Any units more than 600(C4) cost $1.4018 each

Work out the currency value of the units available i.e. B6 in a single cell?

This follows on from my earlier posting about calculating the total unit value obtained when units are purchased on the same sliding scale with a subject of 'Calc sliding scale formulae?' whose spreadsheet you will find on Nabble.

Help appreciated after you have stretched the brain matter. Does the same happen in newer versions of Calc?

Regards
Hylton
--
========================================================================
Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A)
http://e-clubhouse.org/sites/fishhoek/index.php being part of the worlds
largest non profit NGO
========================================================================


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.