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

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

Hi Eivind

Two things, your formukl has a paranthesis problem, and as you want to
compare against 101% you are missing a % sign or you should use 1,01 in you
formula.

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

Test and see if you get the result you need now.

Regards,
Per

"Eivind" skrev i meddelelsen
...
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

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

Hi,
first the parhentesis is in the wrong place

=If(and(100/I6)*I7101; I7<I6); 1; 0)

but I have a question you are comparing 101% what in excel if you see 101%
the number there is 1.01 formated as a % will show 101%. If this is the case
you need to change your formula to

=If(and(100/I6)*I71.01; I7<I6); 1; 0)

hope this helps

"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