Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |