And function into If function
 

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

And function into If function
 

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

And function into If function
 

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

And function into If function
 

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

And function into If function
 

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