If Formula

[Guest]

I would like to create a formula that looks at the previous six cells in a
row and if they are all the same value it increased the value in the seventh
cell by a certain percentage. For example, if the cells in A1:F1 all had the
value of 100 it would put a value of 150 (100 plus 50% of 100) in G1. If the
values in A1:F1 were not the same it would simply put the value in F1. Thank
you in advance for your cooperation.

 

[Guest]

Use the "AND" function...

=IF(AND(A1=B1,B1=C1,C1=D1,D1=E1,E1=F1),F1*150%,F1)

 

[JE McGimpsey]

One way:

=IF(COUNTIF(A1:F1,F1)=6,1.5,1)*F1