Forum Discussion
sarahn1985
Jul 13, 2022Copper Contributor
annual leave days formula
hi 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 f...
ecovonrein
Jul 13, 2022Iron Contributor
Cannot work out whether you are doing VBA or Excel. Either language requires an AND.
- VBA: IF 6 <= G1 AND G1 < 12 THEN ...
- Excel: =IF(AND(6<=G1;G1<12); ...