Home >> Forums >> Questions >> Excel?

Excel?

Log in or register to add a reply.
2bAgen
2bAgen
Mar 18th 2010, 22:26
Hehe... Well, I wasn't sure if anyone knows this.

I have a visit list in excel, and was wondering if anyone could help me with this.


I'm lazy, and I want to be able to type the name of who visits me/who I visit, and then the number of visits owed would go up/down.

I have trouble with the IF function. i.e. =IF(G2=L4, +1,)

The trouble is that it doesn't add, it just displays the number 1. I'm not sure how you'd get it to add once only either...


If anyone knows, please tell me.
beto1
beto1
Mar 19th 2010, 11:17
precocious. Btw, looks like I owe ya a visit. Remind me about it later.
Nokke
Nokke
Mar 20th 2010, 19:49
Please send me your excel file and i can check if i know something. I can't help now because i need to see what is situation... nokkeri@wippies.fi

I saw that you had space in there so try this one: =IF(G2=L4+1) It's nearly impossible say whats wrong, without seeing the situation
Log in or register to add a reply.