Formula To Increase Number By %

October 28, 2010 at 02:22:42
Specs: Windows XP, core 2 /2GB
i need to times some values but not sure how it's done...Pls help
If the user is GRADE 3 or above he/she is entitled to have 10% extra to the sum of he/her basic salary. What is the formula i need to input in COLUMN : TOTAL
many thanks!


eg NAME GRADE BASIC SALARY EXTRA BONUS TOTAL

Steveson 3 1000 10% 1100
John 2 1000 10% 1000
Karen 1 1000 10% 1000



See More: Formula To Increase Number By %

Report •


#1
October 28, 2010 at 07:52:53
With your data like this:

     A        B         C             D          E
1) NAME     GRADE  BASIC Salary  Extra Bonus   Total
2) 
3) Steveson   3      1000          10%          1100 << =IF(B3>=3,(C3*D3)+C3,C3)
4) John       2      1000          10%          1000
5) Karen      1      1000          10%          1000

Put this formula in cell E3 and drag down. =IF(B3>=3,(C3*D3)+C3,C3)


MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question