How to repeating many formulas
I have the following formula
"=if($a$1=$b$1-1,1,if($a$1=$b$1,2,if($a$1=$b$1+1,3,if($a$1<$b$1-1,if($a$1<$b$1,if($a$1<$b$1+1,SUM($b$1,b2))))))) .
I want to repeat that formula without having to use the tedious
edit/copy/formula method since I have thousands of comparisons. Can you
help? Thanks
|