Good Afternoon,
I have a v look up table but the rate calculation is contingent on whether or not the pay calculation in another cell exceeds 50,000 dollars. How do I add the if statement to read the salary cell then calculate the rate if it is over 50K?
Thanks, BD6!
Here is the formula...
=VLOOKUP(B14,$A$1:$B$11,2)
Bookmarks