Home
|
Forums
|
Help
|
Login
|
Sign up
Create your own hotel, it's FREE!
Home
>>
Forums
>>
Questions
>> Excel?
Excel?
Page 1 out of 1.
Log in
or
register
to add a reply.
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
Mar 19th 2010, 11:17
precocious. Btw, looks like I owe ya a visit. Remind me about it later.
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
Page 1 out of 1.
Log in
or
register
to add a reply.
Mar 18th 2010, 22:26
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.