Formula help, chaning a cell number within the formula

M

miliwen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

simplify equation 3
formula to count number of months that have passed 5
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) 7
Need help with a formula, please!!! 2
Cell ref is it possibile to calculate / change this in a formula 3
A staying on schedule formula: 2
Help with MACRO to Edit WORKDAY Formula? 2
Needing Help 3

Top