Board 8 > Can someone super knowledgeable on Excel functions help me out?

(+) Yeah! (+)

Trying to figure out the formula for something, hopefully it exists.


Example:

1. Twenty entries (20 cells), they contain one of three words.
2. I want to be able to type in the correct word into a cell.
3. I need a formula that matches the words and if they're the same, spit out a number into another cell and if they're not then spit out a zero into another cell.

Is this possible?

--
Menji - Sign My Petition for "Search By Username"
http://www.gamefaqs.com/boards/7-site-suggestions/55168396

So the correct word is a cell, and you're checking each of the 20 entries to see if they match that word? I think a regular IF formula works, yes?

=IF(A1=B1,truenumber, falsenumer)
where A1is the test word cell and B1 is the correct cell.

--
.

Excellent!

Now... it's working in excel but when I try to do it in Google Spreadsheet it just keeps the formula and doesn't show the value I want...

Any idea on that?

--
MENJI http://i.imgur.com/a8MU1.png
by Lisel: http://img.imgcake.com/Menjipngmy.png

In Excel, copy your values and right click -> Paste special -> Paste as Values

then try bringing it over

--
~Wigs~
New York FOOTBALL Giants: SUPER BOWL XLVI CHAMPIONS

WIGS I NEED TO BE ABLE TO DO THIS LIVE

I can't be copying and pasting!

--
Menji~ and you could write a Bad Romance
http://img686.imageshack.us/img686/508/badk.gif

There's a button on the far right of the Formula Bar that says "show all formulas"

If that's on, you won't see the evaluated value of the function

--
_foolmo_
'he says listen to my story this maybe are last chance' - ertyu quoting Tidus

heh, I had clicked that earlier thinking it would list all the formulas to use.


nice

--
Menji - www.last.fm/user/menjii
You got to put me on. Come on! Come on!

Okay new one.

Say some of the values coming out are 0, 1, 2, or 3. If I want to count the cells that are not 0 what would I use? I have this but I get an N/A:

=if(E9:O9,Q9:Z9,AB9:AD9>0,count(E9:O9,Q9:Z9,AB9:AD9),0)

--
Menji - www.last.fm/user/menjii
You got to put me on. Come on! Come on!

If you don't have numbers in P9 and AA9, you could use this formula:

=COUNTIF(E9:AD9,">0")

Okay, I simplified the formula. Earlier, I had a more complicated formula that still gets the job done.

--
Luster Soldier --- ~Shield Bearer~ | ~Data Analyst~
Popular at school, but not as cool as SuperNiceDog, Guru Champ!

I do, but I was able to tweak that so it works.

=COUNTIF(AB9:AD9, 1)+COUNTIF(Q9:Z9, 2)+COUNTIF(E9:O9, 3)

Thanks!!

--
MENJI http://i.imgur.com/a8MU1.png
by Lisel: http://img.imgcake.com/Menjipngmy.png