ANNUAL LEAVE DAYS DESERVED ACCORDING TO UAE LABOR LAW

[sdubai]

hi dear

this is for calculating annual leave DAYS deserved

if G1>=12 (months) THEN G1*2,5
IF 6 (months)<=G1<12 (months) THEN G1*2

how can i combine in 1 formula, it is working for one condition not for the other.

thanks

 

[bebo021999]

=IF(G1<6,0,IF(G1<12,2,2.5))*G1

use "," or ";" depend on your current decimal setting