do not increment variables in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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

hth
Carlo
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array VLOOKUP lookup_Value does not increment 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Cell Counter/Increment 2
VBA Code Writing to Excel Box Name 3
Need urgent help 0
Dynamically increment date for data import from another spreadshee 4
Does variable set to cell value automatically becomre cell value? 2
increment IP address. 1

Back
Top