Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Rabiah Begum    on Jan 29 In MS Office Category.

  
Question Answered By: Salvatore Kelly   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...

Share: