Writing if statement in excel.

  • Thread starter Thread starter Lsum
  • Start date Start date
L

Lsum

Hello,
I'm new to excel and need help in writing IF statement to return valu
on bonus due.
I need to calculate longevity bonus based on years of service
0-4 yrs= $0, 5 - 9 yrs = $1000, and 10yrs or more = $1500.

Cell F = yrs of service.
Cell L = longevity bonus.

Please help!!!

Lsu
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula 5
Average Calculations 11
if function 5
Need Help with IF Function 1
Calculate duration (#yrs., # mos.) 2
Problem with an IF formula 2
Multiple if statements 5
Nested IF & AND functions 4

Back
Top