do not increment variables in excel
 

I can't seem to get certain values in my OR and IF statements to NOT
increment when I copy the equation down a column

do not increment variables in excel
 

On Nov 7, 10:21 am, mknappenb
wrote:
I can't seem to get certain values in my OR and IF statements to NOT
increment when I copy the equation down a column

Write the formula in the second cell also manually and then copy both
down.

hth
Carlo

do not increment variables in excel
 

Did you use the <F4 key to change the addressing style when creating the
formula?

In other words,
=IF(A1=1,B1,C1)
....will adjust all references when copied or filled down the column.

=IF($A$1=1, B1, C$2)
....will NOT adjust the $A$1 reference and WILL adjust the B1 reference when
filling down. The C$2 reference will NOT change the row number of when
filling down, but WILL change when filling horizontally to the right or
left.

Select each reference, then press the <F4 key to cycle the reference style
from absolute to relative (there are 4 different combinations).

--
Regards,
Bill Renaud