Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

False verses 0

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

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

 

4 Answers Found

 
Answer #1    Answered By: Aaron Evans     Answered On: Jan 29

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

 
Answer #2    Answered By: Salvatore Kelly     Answered On: Jan 29


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

 
Answer #3    Answered By: Deloris Harris     Answered On: Jan 29

You could try -

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

 
Answer #4    Answered By: Luisa Fischer     Answered On: Jan 29

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.




Tagged: