|
Hi Anthony, Further to my earlier email. =LOOKUP(1;M12:M791;C12:C791) The search for "1" is a product of then IF statement =IF($I$8>H14;1;0) =IF($I$8>H15;1;0) =IF($I$8>H16;1;0) Etc Therefore I end up searching a column which has 0's until the IF statement is true (1). Then the column changes to 1's. Earlier versions would search for the first 1 (one) in the column. Version 2 searches for the last 1 (one) in the column. My question now will be : How many of the other Calc functions have been changed ? I depend on these spreadsheets for legal documents ! Can I trust my spreadsheets in a court of law ? Or do I need to proof check every spreadsheet generated with earlier versions of OpenOffice Calc ? I have solved the problem of missing / corrupt Calc help files (thanks to the forums out there). Would have thought that this little problem would have be resolved very quickly. Cheers, Max. Anthony Chilco wrote: Hi Max, |
No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.14.23/240 - Release Date: 25/01/2006
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
