Having trouble with the IF formulas in Microsoft Excel?

Question

I have to make an IF formula up using the following information and I am having the hardest time undrerstanding how the if function works. Heres the problem:
If the employee received a performance rating of 4.0 or higher OR $40,000 or more, the eployee receives 5% of his/her base salary. IF the employee did not receive a 4.0 rating or higher or doesen't earn $40,000, the employee receives 3% of the base salary.
I know how I have to use OR in the function but it doesn't seem to want to work am i setting up the formula incorrectly, please help.

Answer 1

maybe this will help:

http://spreadsheets.about.com/cs/excelfunction1/a/iffunction.htm

Answer 2

Frankly I think the logic is not quite right.

If PERF >= 4 *or* EARN >= $40,000, then RAISE = 5% => This means either the first or second condition must be true to get 5% raise.

If PERF < 4 *or* EARN < $40,000, then RAISE = 3% => This means either the first or second condition must be tru to get 3% raise. However, you can see that this contradicts the first IF (5%).

For example: PERF = 4, but EARN <= $40,000 => Based on your formulas, RAISE can be either 3% or 5%.

If you change one of the *or* condition to *and*, that will be valid. But this depends on your case.

So the EXCEL formula will be either one of these:

=IF(AND(B1>=4,B2>=40000), 0.05*B3, 0.03*B3)
or
=IF(OR(B1>=4,B2>=40000), 0.05*B3, 0.03*B3)

NOTE: B1 = PERF, B2 = EARN, B3 = BASE

Hope this doesn't add your confusion :D

Answer 3

not effective why you're having a difficulty. basically basically be sure you're putting each and everything contained in the right position: A1=15.2 B1=round(A1,0) extremely, the round() formulation can go in any cellular you want, except in A1 itself because it is the position the formulation is taking enter. the end results of the formulation (15) will happen contained in the sheet, notwithstanding the formulation will coach contained in the get properly of entry to field above once you opt for B1. also basically be sure you type the equivalent signal (=) before you enter any formulation.

Answer 4

Use this:
=IF(OR(rating>=4,salary>=40000 ),0.05*salary,0.03*salary)
where rating is where your performance rating is located and salary is where your salary is located. (Take out the space after 40000; it's just there so the whole formula will show up.)

Answer 5

You can use nested IF's.

=IF(B1 >= 4, 5, IF(C1 >= 40000, 5, 3))

Answer 6

isn't that a learning office homework question? look in the textbook.

=IF(OR([cell with performance rating]>=4,[cell with base salary]>=40000),[cell with base salary]+([cell with base salary]*5),[cell with base salary]+([cell with base salary]*3))

Answer 7

=IF(A2>3,0.05,IF(B2>39999,0.05,0.03))

A column contains ratings, B column contains amounts, formula in the C column.