If condition:one cell is greater than previous cell by at least a certain %?

[captnamazing]

Does anyone know how to include a condition in the condition? What I mean is in this set of numbers:
1000(A) 1000(B) 1000(C) 1200(D) 500(E) 1000(F)

I want excel to point out (with a 1, True, x, whatever) if (B) is greater than (A) by 10% or more and if (C) is greater than (B) and so on.

I know I cant use =if(C>B,1,0)...Im just unsure how to include the % in the function

Any help would be appreciated... Thanks

[shg]

Welcome to the forum.

= b1 >= 110% * a1

If you want one formula for all,

=SUMPRODUCT(--(B1:F1 >= 110% * A1:E1)) = 5

[captnamazing]

Thanks for the welcome AND thanks for the help that was exactly what I was looking for.