And function into If function

  • Thread starter Thread starter Eivind
  • Start date Start date
E

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
 
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
 
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
 
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)
 
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
 
Back
Top