Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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.

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")))

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

getting.

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.

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.

Related Topics:

- Can Any one help me writing logic for the given formula
- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- VBA Formula prob
- Getting a formula to copy from inside VBA
- Populate Formula(Function) in rows
- searching within formulas
- Formula using range name in VBA code
- Three Leveled Formula
- R1C1 Formula
- Paste Formula help
- VBA or array formula?
- VBA code to add values in two cells which have formulas
- combining formula
- How to add several conditions for formula "SUMIF"
- formula help but not vba please
- Loop in formula
- Copy down formula with vba
- Array Formula
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- Stuck on copying formula from 1 sheet to another
- Named formula/Windows dialog boxes
- cells containing formula that refer to user-defined VBA function
- sum formula
- Manually creating a row outline with no formula anywhere
- Blank Formula bar