Writing if statement in excel.

[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

 

[Frank Kabel]

Hi
enter the following in L1
=IF(F1>=10,1500,IF(F1>=5,1000,0))