Using the IF function for salary coding

**henesy** · 08-09-2009, 12:01 AM

Salary codes:

If C5=1, I want O5 to equal 49.11
If C5=2, I want O5 equal to 98.22
If C5=3, I want O5 to equal 49.11*1.05

This seems so elementary and yet it eludes me.

Can someone help me?

**contaminated** · 08-09-2009, 12:25 AM

In O5

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

**henesy** · 08-09-2009, 12:40 PM

wow.. thank you very much!

**contaminated** · 08-09-2009, 04:42 PM

If it meets your requirements, mark the thread as "SOLVED", and don't forget to add reputation by pressing blue scales on the right of your screen

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save