You have one of your closing brackets in the wrong place. Try it this
way:

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

Hope this helps.

Pete

On Dec 17, 12:31*pm, 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