mark gardner
Board Regular
- Joined
- Sep 6, 2006
- Messages
- 58
I have a sheet where I need to input a number and if the number is 1, I need a corresponding cell to return a 1, if it is a 2, I need a 3 (1+2), if it is a 3, I need a 6 (1+2+3)...etc. Is there a formula I can use?
thanks in advance
thanks in advance