 Search:

# MS Office Forum

Ask Question   UnAnswered
RSS Feeds

# Any idea how to write formula?

Asked By: Fahimah    Date: Aug 31    Category: MS Office    Views: 1787

Here I go again being a bit nervy asking for help.
I have been going on line looking how to do this one. I just keep getting an
error message when I write the formula in. Any idea to get me started would
be appreciated.

Any idea how to write this formula?

A10 – At Bat
A11 – Hits
A12 – Poor Hitter <.=250
A13 – Good Hitter >

A player’s batting average is determined by dividing the number of hits by
the number of times at bat. In cell B12 we must divide B11 by B10. If the
result is < or = .250, then you should print the label poor hitter. If it
is better than .250 than leave the cell blank.
In B13 the condition is if B11 divided by B10 is greater than .250, than the
true argument would be to print the label Good Hitter. If it is false leave
the cell blank. Format cells B12 and B13 so they will print 3 decimal
places.

Share:

### 4 Answers Found

Answer #1    Answered By: Jana Franklin     Answered On: Aug 31

I'm not sure if you want B12 to just return "Poor Hitter" or "Poor Hitter" plus
the batting average  (ditto for B13 and "Good Hitter"). The following formulas
return the label plus the batting average:

B12: =IF(\$A\$10=0,"",IF(\$A\$11/\$A\$10<=0.25,"Poor Hitter " &
TEXT(\$A\$11/\$A\$10,".000"),""))

B13: =IF(\$A\$10=0,"",IF(\$A\$11/\$A\$10>0.25,"Good Hitter " &
TEXT(\$A\$11/\$A\$10,".000"),""))

Or, you could do it all in one cell: =IF(\$A\$10=0,"",IF(\$A\$11/\$A\$10<=0.25,"Poor
Hitter "& TEXT(\$A\$11/\$A\$10,".000"), "Good Hitter "& TEXT(\$A\$11/\$A\$10,".000")))

Answer #2    Answered By: Clay Cook     Answered On: Aug 31

You haven't shown us the formula  you are typing or told us the error you are
getting.

Answer #3    Answered By: Josephine Gomez     Answered On: Aug 31

I am not sure what I am doing
At Bat12
Hits3
Poor Hitter<.250TRUE
Good Hitter>.250FALSE =(B11/B10>0.25)

I have different answer as well and they do not match.

Answer #4    Answered By: Aadi Martin     Answered On: Aug 31

3/12 is EXACTLY .25...
You're not telling Excel what to do if it is .25, just < or >
so, use <= if you expect .25 to be "Poor".

Didn't find what you were looking for? Find more on Any idea how to write formula? Or get search suggestion and latest updates.

Tagged: