Ok...just to make sure I understand...you want 1-4 values to be reversed 4-1. If c2 is where the original value is then in the cell you want to show the modified value put the formula "=5-C2"