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?
- Copy Value produced by formula in cell C3 to cell D3
- 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
- Disabling Formulas, Not calculation
- Quotations in Formulas and strings
- Formula with conditional text
- Please Help me in this Formula
- Constructing Address formulas
- formatting text which is in text formula
- formula returns to multiple cells, without Array object?
- 2003 - Moving to a formula address
- formula
- Need of an Excel Formula
- Formula to match,lookup and then retun alternate value
- Stuck on copying formula from 1 sheet
- Using an array formula as a hyperlink cell reference
- How to detect formula where it is refrering same row
- VBA Code for pasting a set of formulas down a data range
- Formula multiplying ActiveCell with "F11"