Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

=IF(B11/B10<=0.25,"Poor Hitter")

When I apply this formula is says false but I need it to say 0.

Is there a way to write the formula that will say 0 instead of false?

=IF(B11/B10<=0.25,"Poor Hitter",0)

Do you have "Tool Tips" turned on?

If you do, Excel will give you help as you type the formulas, highlighting the

part of the formula you're entering.

With the IF statement, there are three parts, separated by commas.

1) What to test (that returns True or False) (in your case, the B11/B10 <=.25)

2) What to do if the result from (1) is True (in your case, display "Poor

Hitter")

3) What to do if the result from (1) is False (missing from your example)

If you leave out a part, then Excel has to decide what to do, or display an

error.

By leaving out the third part, Excel chose to display the result from the test

expression.

hope this helps you understand.

BTW... NOT that we are opposed to helping a novice take their first steps into

the Wonderful World of Spreadsheets,

but you've found your way into a Visual Basic for Applications Excel group.

which, basically is a Visual Basic programming group.

What you're looking for is a Excel user group, which there are.

It's kind-of like asking the guy that designs fuel injection systems for indy500

race cars

if he knows where the gas tank is on your mom's van.

Ok.. not quite...

You could try -

=IF(B11/B10<=0.25,"Poor Hitter", 0)

Thank you everyone for the help on excel.

Didn't find what you were looking for?
Find more on False verses 0
Or get search suggestion and latest updates.

Related Topics: