And function into If function

[Eivind]

I´m trying to get this function to work. But I´m getting an error message.
=If(and(100/I6)*I7>101); 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

 

[Pete_UK]

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

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

Hope this helps.

Pete

 

[Per Jessen]

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)*I7>101%; I7<I6); 1; 0)

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

Regards,
Per

 

[Luke M]

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)*I7>101; I7<I6); 1; 0)

 

[Eduardo]

Hi,
first the parhentesis is in the wrong place

=If(and(100/I6)*I7>101; 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)*I7>1.01; I7<I6); 1; 0)

hope this helps