Hi Eugénio, Below is a example that's similar to your case. The first row is the actual data. The second row is a copy of the first, but formatted to display as shown. The numbers are the same, just rounded to fit the format.
A B = A * B 4.104 4 16.416 4.10 04 16.42 tc Eugénio Varejão wrote: > Greetings! > > I have a template in calc that have an error but I don't know where it > is and how can I correct it. > > A B C D > F E G H > *POS* *Quant.* *Cod* *Marca* *Descrição* *PU* > *Desc.* *PT* > *01* 04 SICHCS03T SI Chassis Porsche 962 4,10 € > 16,42 € > > > The formula under PT is "=IF(B7<>"";(F7*B7)-(F7*B7)*G7;"")" for this > result should be 16.40 €. > > Where is the error? > > Kind regards, > Eugénio Varejão > > > _________________________________________________________________ Chat with the whole group, and bring everyone together. http://go.microsoft.com/?linkid=9650735
