| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Formula
I have this formula:
=IF(ISNUMBER(C6/B6);(C6/B6);0) Is there a way to copy the formula in each cell in the row so that the division will work like this: next cell in row (E6/D6) next cell in row (G6/F6) and so on. Thank you in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Formula
=INDIRECT(CHAR(COLUMN()*2+63)&6)/INDIRECT(CHAR(COLUMN()*2+62)&6)
"carl" skrev: I have this formula: =IF(ISNUMBER(C6/B6);(C6/B6);0) Is there a way to copy the formula in each cell in the row so that the division will work like this: next cell in row (E6/D6) next cell in row (G6/F6) and so on. Thank you in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Formula
Thank you so much for your help.
I did not copy my original formula correcty in the original post. My original formula is this: =IF(ISNUMBER(Sheet4!C6/Sheet4!B6);(Sheet4!C6/Sheet4!B6);0) What to do ? Thanks again. "excelent" wrote: =INDIRECT(CHAR(COLUMN()*2+63)&6)/INDIRECT(CHAR(COLUMN()*2+62)&6) "carl" skrev: I have this formula: =IF(ISNUMBER(C6/B6);(C6/B6);0) Is there a way to copy the formula in each cell in the row so that the division will work like this: next cell in row (E6/D6) next cell in row (G6/F6) and so on. Thank you in advance |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Formula
try
=OFFSET(Sheet4!$A$6,0,COLUMN()*2-2)/OFFSET(Sheet4!$A$6,0,COLUMN()*2-3) "carl" skrev: Thank you so much for your help. I did not copy my original formula correcty in the original post. My original formula is this: =IF(ISNUMBER(Sheet4!C6/Sheet4!B6);(Sheet4!C6/Sheet4!B6);0) What to do ? Thanks again. "excelent" wrote: =INDIRECT(CHAR(COLUMN()*2+63)&6)/INDIRECT(CHAR(COLUMN()*2+62)&6) "carl" skrev: I have this formula: =IF(ISNUMBER(C6/B6);(C6/B6);0) Is there a way to copy the formula in each cell in the row so that the division will work like this: next cell in row (E6/D6) next cell in row (G6/F6) and so on. Thank you in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| want to copy formula, only change one number in formula | Excel Worksheet Functions | |||
| Copy Formula Down Without Changing Entire Formula | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Copy formula so destination displays formula as text | Excel Discussion (Misc queries) | |||
Hybrid Mode
