Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Reference
What I am looking for is that when I enter a formula (In cell B1) to pick up
value in A1. Now I need value from cell A5 in cell B2. Next value I need in B3 is A9. Everytime I have to change the cell values manually in column B. Formula I use : - =IF(OR(AK64<$D$4,AK64=$D$4),H331,0) Now I need value from cell H336 and I manually change H331 to H336 shown below =IF(OR(AK64<$D$4,AK64=$D$4),H336,0) Any way to make this automated. Thanks Ankur Bhateja |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Reference
Instead of =IF(OR(AK64<$D$4,AK64=$D$4),H331,0)
you could say =IF(AK64<=$D$4,H331,0) If what you want is to be able to step the H331 5 rows down when you copy the formula down a row, without the other references changing, try =IF(AK$64<=$D$4,OFFSET(H$331,5*(ROWS(A$1:A1)-1),0)) -- David Biddulph "Ankur Bhateja" <Ankur wrote in message ... What I am looking for is that when I enter a formula (In cell B1) to pick up value in A1. Now I need value from cell A5 in cell B2. Next value I need in B3 is A9. Everytime I have to change the cell values manually in column B. Formula I use : - =IF(OR(AK64<$D$4,AK64=$D$4),H331,0) Now I need value from cell H336 and I manually change H331 to H336 shown below =IF(OR(AK64<$D$4,AK64=$D$4),H336,0) Any way to make this automated. Thanks Ankur Bhateja |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |