Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I increment a column in Excel | Excel Discussion (Misc queries) | |||
How to Increment Time using EXCEL ?? | New Users to Excel | |||
How to Increment Time using EXCEL ?? | Excel Programming | |||
Increment/Increment letter in alphabetical order | Excel Programming | |||
Increment a counter in Excel | Excel Worksheet Functions |