MS Excel If Function problem

Asked By arup123 0 points N/A Posted on - 10/02/2011

Recently I have installed MS Office 2003 and working on it. I am creating so many worksheets. But I have a problem with if functioned. I can not use it properly. What are the using rules of this function?

• Status: Open
• Question Views: 1147
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by DaniellMaymon

Go To Solution

Best Answer

Best Answer

Answered By DaniellMaymon 0 points N/A #85193

MS Excel If Function problem

Yes there is a proper format for if function in MS excel. You can not use it in your own way. You need to follow instructions and rules for using for if function in MS excel. Here I am giving a syntax and example for it. But you need to use it at your own way.

 

If the syntax is: IF(logical_test, value_if_true, [value_if_false])

Example is : 

 

1. =IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F"))))

2. =IF(A2>B2,"Over Budget","OK")

3. =LOOKUP(A2,{0,60,63,67,70,73,77,80,83,87,90,93,97},{"F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"}

 

The lookup function is similar as if function. And it is a part of if function.

This is how to use if function in MS excel. These are only format. You have to use your condition in this type of format.

About DaniellMaymon

Questions
0

Answers
4

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 10/02/2011
• Question Category: MS Excel

Answered By alphae 15 points N/A #85195

MS Excel If Function problem

The IF function in ms excel is basically used to test whether a condition is true or false. When using excel, in the menu there is a function named fx, you just click on it and a dialog box will pop up. In the dialog box double click on IF from the list of functions given, another dialog screen will pop up. Type in the expression that you want to evaluate then click ok.

Expression example:

LOGICAL TEST IF(A1>50)

VALUE IF TRUE “PASS”

VALUE IF FALSE “FAIL”

The IF expression returns a value as true if the condition is met and false if the condition in not met.

Check attached images to see how the function is used.

About alphae

Questions
1

Answers
45

Best Answers
15

• Vote Up 0 Vote Down

• Posted on - 10/02/2011
• Question Category: MS Excel