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.
2006-07-27
11:08:28
·
7 answers
·
asked by
ehall0731
1