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

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