Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drag formula problem
Im using this formula below but when I try to drag down the formula row B45
& B46 is moving down as well, when actually it should remain in B45 & B46 only B8 should be B9 C8 should be C9 and so on. =(B8=$B45)*5+($B46=C8)*(($B46-4)+(B8=$B45)*(9-C8)) Thanks ahead |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drag formula problem
Buy a book on basic Excel and read it? Concerning absolute and relative
addressing? I know that reading a book is hard work. But .................... $B locks the column in, $45 locks the row in: as in $B$45 DUH!!! "Killer" wrote in message ... I'm using this formula below but when I try to drag down the formula row B45 & B46 is moving down as well, when actually it should remain in B45 & B46 only B8 should be B9 C8 should be C9 and so on. =(B8=$B45)*5+($B46=C8)*(($B46-4)+(B8=$B45)*(9-C8)) Thanks ahead |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drag formula problem
Modify $b45 as $b$45, $b46 as $b$46
=(B8=$B4$5)*5+($B46=C8)*(($B$46-4)+(B8=$B45)*(9-C8)) Best wishes Sreedhar "Killer" wrote: Im using this formula below but when I try to drag down the formula row B45 & B46 is moving down as well, when actually it should remain in B45 & B46 only B8 should be B9 C8 should be C9 and so on. =(B8=$B45)*5+($B46=C8)*(($B46-4)+(B8=$B45)*(9-C8)) Thanks ahead |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drag to fill a formula - problem! | Excel Worksheet Functions | |||
Drag formula down | Excel Worksheet Functions | |||
Drag Formula Until ( ) | Excel Discussion (Misc queries) | |||
drag and drop problem | Excel Discussion (Misc queries) | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) |