Search found 1 match

by rahman
Wed Feb 17, 2010 3:53 pm
Forum: HCM (Human Capital Management)
Topic: fast formula help
Replies: 1
Views: 1457

Dear Sami Try the below formula X = (annl_sal * 0.1) - (assur) IF X >= 1000 THEN ( IR = (X * 0.1) RETURN IR ) ELSE IF X < 1000 AND X >= 2000 THEN /* X = 1800 */ ( a = (1000 * 0.1) /* a = 1000 * 0.1 = 100 */ Y = X - 1000 /* Y = 1800 - 1000 = 800 */ IR = a + (Y * 0.15) /* IR = 100 + 120 = 220 */ RETUR...