Search:

# False verses 0

Asked By: Rabiah    Date: Jan 29    Category: MS Office    Views: 610

=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?

Share:

=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
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.