Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help, chaning a cell number within the formula
Hello,
Right now I have a few hundred rows that need to be calculated. The formula is this: =IF((J7="Y"),F7*0.66,IF((J7="N"), F7, IF((J7=""), F7))) I need this formula copied a few hundred times, but x7 needs to change on the given row. Example, for row 8, I would need: =IF((J8="Y"),F8*0.66,IF((J8="N"), F8, IF((J8=""), F8))) Copying and pasting this over and over, and then changing the number is becoming very tedious. Thanks for any help! suadeo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help, chaning a cell number within the formula
Ignore this, I figured it out. Sorry for wasting anyones time.
suadeo wrote: Hello, Right now I have a few hundred rows that need to be calculated. The formula is this: =IF((J7="Y"),F7*0.66,IF((J7="N"), F7, IF((J7=""), F7))) I need this formula copied a few hundred times, but x7 needs to change on the given row. Example, for row 8, I would need: =IF((J8="Y"),F8*0.66,IF((J8="N"), F8, IF((J8=""), F8))) Copying and pasting this over and over, and then changing the number is becoming very tedious. Thanks for any help! suadeo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |