Excel formula for cell G20 where it will return 14.5 if the number in cell I2 is 20-39, 14 if the number is 40-59, 13.5 if the number is 60-79, 13 if the number is 80-99, and 12.5 if the number is 100 or greater.
Excel formula for cell G20 where it will return 14.5 if the number in cell I2 is 20-39, 14 if the number is 40-59, 13.5 if the number is 60-79, 13 if the number is 80-99, and 12.5 if the number is 100 or greater.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks