Change The Formula

[DeppSun]

Hi,

I want to copy this formula another cell. Table is vertical but reference cell horizantal. In workbook 125 column exist. When i try copy the formula, bold value is not changing. It must be 5, 6, 7... 125.

Thanks..

IF(OR($D5=İzin_Planı!$J4;$D5=İzin_Planı!$L4;$D5=İzin_Planı!$N4;$D5=İzin_Planı!$P4;$D5=İzin_Planı!$R4;$D5=İzin_Planı!$T4);1;IF(OR($D5=İzin_Planı!$K4;$D5=İzin_Planı!$M4;$D5=İzin_Planı!$O4;$D5=İzin_Planı!$Q4;$D5=İzin_Planı!$S4;$D5=İzin_Planı!$U4);1;IF(OR((AND($D5>İzin_Planı!$J4;$D5<İzin_Planı!$K4));(AND($D5>İzin_Planı!$L4;$D5<İzin_Planı!$M4));(AND($D5>İzin_Planı!$N4;$D5<İzin_Planı!$O4));(AND($D5>İzin_Planı!$P4;$D5<İzin_Planı!$Q4));(AND($D5>İzin_Planı!$R4;$D5<İzin_Planı!$S4));(AND($D5>İzin_Planı!$T4;$D5<İzin_Planı!$U4)));1;0)))

 

[mole999]

you say copy, do you mean you can't drag it to new cells and have it change ?

 

[DeppSun]

There's no any file protection. I can drag or copy.

 

[baodinh]

If you are copy down, the row numbers will change. If you are copying across, the column numbers will change. As you have absolute referenced the columns ($J, $D), it won't change. Try changing your data to vertical and copy down.

 

[DeppSun]

If you are copy down, the row numbers will change. If you are copying across, the column numbers will change. As you have absolute referenced the columns ($J, $D), it won't change. Try changing your data to vertical and copy down.

Is there any alternative way?

 

[baodinh]

Not that I know of. Changing the data from column to rows is easy if you use the Paste Special option and tick the transpose box.

 

[DeppSun]

Not that I know of. Changing the data from column to rows is easy if you use the Paste Special option and tick the transpose box.

I was try tick the transpse box.