=IF(AND(Sheet1!E31>=17.5,Sheet1!E31<=18),Sheet1!E31,0)
How can I change E31 to E39 in this formula and then E39 to E47?
I have to increment the cell reference by 8 - 125 times
All help is appreciated
=IF(AND(Sheet1!E31>=17.5,Sheet1!E31<=18),Sheet1!E31,0)
How can I change E31 to E39 in this formula and then E39 to E47?
I have to increment the cell reference by 8 - 125 times
All help is appreciated
What row does the formula start in?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I attached the spreadsheet in a later email - thank you
This is a duplicate thread!
Yes-I know it was an accident! Sorry! Can you help me?
Administrative Note:
Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.
Please see Forum Rule #5 about thread duplication.
I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...a-formula.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks