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

Hi Steve,

Your input provided the solution to the formula syntax and use.

Had you looked, I am assuming you did not, at the Nabble document I had
uploaded with the original question you would have seen the correct values
for some of the  'Givens' you listed i.e. 

If you have G2 as your input,   CORRECT
F18 = 1.132   CORRECT
G18 = 150     Correct
H18 = Rand Value of 150 units at the unit price ie F18*G18 = R169.80
I18 = 1.1811
J18 = 449.90
K18 = I18*J18 = R531.38
L18 =  1.4018
M18 =  600.01
N18 =  841.09

Calculate your answer with: 
it gives an INCORRECT answer.

Using Your formula as a template, I rectified a mistake or two and arrived
at this formula:


to achieve the the correct answer for cell H2 ie R504.05 as a unit value for
433 units in C2.

I removed the $ around $G$2 as it is the reference that has to change ie
Because only the scale cell figures are absolute ie with $, the formula can
be copied down the column of H from cell H2 all the way to H13 with only the
initial cell reference G2 changing along the way ie G3,G4,G5 etc.

Thank you VERY much for the assistance of everyone. I have included a Nabble
link to the file, for those who may be interested.



View this message in context:
Sent from the Users mailing list archive at

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.