smart excel question - only for smart user

logikz

I Am Not The King
Tribal Leader
VIP Junglist
Messages
11,117
Likes
2,984
#1
i need a forumla that does +1 in a cell, beginning from 0 regardless of what number pressed on keypad?
 

safety

double safety
VIP Junglist
Messages
6,366
Likes
29
#2
so you want excel to add one to whatever number you type? are you trying to fuck with someone or is there a reason you can't just type the actual number you want in there?
 

Greg P

Active Member
VIP Junglist
Messages
2,173
Likes
1
#3
Just go to the cell next to where you're going to enter the number, then type in the box at the top "=(click on the cell where the number is)+1

Does that do it for ya?
 

Dustek

Finished the PhD
VIP Junglist
Messages
5,911
Likes
15
#5
I assume you want to fuck with someone.

Logikz, how good is your command of macros?

For it not be obvious what is going on you're going to have make quite a perverse macro which automatically loads into all spreadsheets. I think I could explain how to do this but it would take a shitload of time.
 
Top