LinkBack URL
About LinkBacks
Hey guys, trying to do a simple formula of 2 if statements in 1 but can't figuire it out. Need something like. IF A1=B2 and if C2 = D2 then the cell equals 2. If one of them don't equal then the cell equals 0.
Cheers,
Hey guys, trying to do a simple formula of 2 if statements in 1 but can't figuire it out. Need something like. IF A1=B2 and if C2 = D2 then the cell equals 2. If one of them don't equal then the cell equals 0.
Cheers,
Last edited by Labl; 04-28-2013 at 03:12 AM.
=if(and(a1=b2,c2=d2),2,0)
If I've been of help, please hit the star
When i use that it throws off my other formula which would be IF A1=B2,1,0...when i use that formula next to it and both dont equal then my first formula goes 0 instead of 1.
In order to understand that I would need to see the workbook. Are you able to attach it?
In my attached sheet, under the james tab, Why doesnt his score come up as 1 under the storm column?
Sorry, which specific cell do you mean?
C3, it should be 1 as A3 in James tab = F3 in results tab.
The reason it doesn't work as expected is some some of your values have trailing spaces.
So 'Storm' on the results worksheet has a trailing space as does the one on the Nathan worksheet, so they match and the formula produces the result you expect. The storm on the James worksheet however has no trailing space so it's not an exact match, meaning the formula doesn't produce the result you expect (but it is actually working).
Cheers that was it!
Glad to help. Sometimes it just takes a new pair of eyes.
Make sure you mark the thread as SOLVED.
Yeah knew it was something small like that. Just 1 more thing.
So just trying to get something to formulate whos coming first etc.
So I have Name in A1 and Score in B1
Is there anyway i can get a formula to say someones coming first.
Cheers
Have a look at the "Current Position" worksheet in the attached.
Column C has a rank based on the scores in column B. Is that the sort of thing you mean?
umm want something saying leader then cell next to it says the person with highest score.
or person with best rank in what you linked.
Cheers
I should use 1 sheet for all the players.
This makes the formulas easier.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks