MS Excel If Function problem

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by DaniellMaymon
Best Answer
Best Answer
Answered By 0 points N/A #85193

MS Excel If Function problem

qa-featured

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.
Answered By 10 points N/A #85195

MS Excel If Function problem

qa-featured

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.

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

Login/Register to Answer

Related Questions