How to Flip Signs for a Range of Numbers in Excel

[@Kyle-p7l]

Great trick, thank you.

[@ExcelSmith]

Thanks. I'm glad you liked it. 😀

[@Svorgy]

Yeah the practical application was I had fantasy football auction values but their values were based on a league with more starting positions than my league. So less players = more money to spend on players and I wanted to increase values per position based on a fixed percentage.

[@ExcelSmith]

Thanks, Andrew. I hope this helped.

[@Svorgy]

I'm a friend!

[@ExcelSmith]

👍