Here is my situation:
Cells A1 to A3 are numbered 1-3.
Cells A4 to A6 are empty.
Cells A7 to A9 are numbered 4-6 if a number higher than 1 is entered into Cell C1.
I need a formula to do the following:
If the number 4 is entered into Cell A4, Cells A7 to A9 should now display the numbers 5-7, but only if a number higher than 1 is entered into Cell C1.
If the number 4 is entered into Cell A4 and the number 5 is entered into Cell A5, Cells A7 to A9 should now display the numbers 6-8, but only if a number higher than 1 is entered into Cell C1.
If the number 4 is entered into Cell A4 and the number 5 is entered into Cell A5 and the number 6 is entered into Cell A6, Cells A7 to A9 should now display the numbers 7-9, but only if a number higher than 1 is entered into Cell C1.
Is there any formula that can do this? Any help would be greatly appreciated.
Bookmarks