Re: [libreoffice-users] Calc scale formula conundrum/ logic confusion

Hi Tom, Brian,

On 14/02/13 10:52, Brian Barker wrote:
> At 07:45 14/02/2013 +0000, Tom Davies wrote:
> > Someone else asked a very similar question about a month ago ...
>
> That "someone else" was (not surprisingly) the same person!
>
> > ... and i think someone created a neat calculation or spreadsheet to
> > help figure it out.  Now the trick is trying to find it in the archives!
>
> He probably doesn't need to ...

Yes its the same person ;) I had hoped I was able to ask more than one 
question about a problem, I mean it is even a different subject/thread.

The value required is a currency value gathered from the sums of the 
different IF values according to a scale.

I have the replies from the previous discussion we had via the list but 
the same formula does not seem to work in 'reverse'? I believe I have 
the right formula, but I think the logic in the IF functions needs checking.

Its not a 'Do my homework please', its a genuine logic oops I think.

Dare I say, that perhaps you also won't spot the error and let me know 
about it. I am sure you would be able to spot the error though? :)

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