It appears your closing parenthsis of the AND arguement is in the wrong
place. Perhaps this is what you are looking for?

=IF(AND((100/I6)*I7101; I7<I6); 1; 0)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Eivind" wrote:

I´m trying to get this function to work. But I´m getting an error message.
=If(and(100/I6)*I7101); I7<I6; 1; 0)
What the function is supposed to do is to detect peak values in chart table
that are measure errors from a measuring intrument and count every peak as 1.

This is how the function is ment to operate:
If the percent of the difference of the rise from the former cell to the
next cell in the sequence of data is larger than 101% AND the value of this
cell is smaller than the former cell then true=1 False=0
Im using a norwegian version of excel and I´m not sure if it´s some error
with , or ; separating the statements.

I would be grateful for any help


Eivind