Friday, May 15, 2009
Next week online test?
Know all these functions
If(condition,true,false)
AND()
VLOOKUP
PMT
SUM(range[vertical,horizontal,range of cells])
MAX
MIN
count(eg Tom Lim Jane)
countif
sumif(if condition true then sum)
Step by step
1)
2) CLICK ON INSERT FUNCTION
3)
END RESULT :
if(condition,true,false)
=if(E5*0.15>300,300,E5*0.15)
IF WAGES = > $900 After you key in... the =IF((E9-F9)<1500,1500,(e9-f9))>
Know all these functions
If(condition,true,false)
AND()
VLOOKUP
PMT
SUM(range[vertical,horizontal,range of cells])
MAX
MIN
count(eg Tom Lim Jane)
countif
sumif(if condition true then sum)
Step by step
1)
2) CLICK ON INSERT FUNCTION
3)
END RESULT :
if(condition,true,false)
=if(E5*0.15>300,300,E5*0.15)
IF WAGES = > $900 After you key in... the =IF((E9-F9)<1500,1500,(e9-f9))>
Formula used to...
To get this:
SUMIF
PMT
CSA
Eg S1
1.one person do Mkt -> sales per month/week/year,products,distribution channel
2.another person do A/C -> B/S, P&L
3.Ops
4.Log -> inbound,outbound,inventory
5.HR -> Payroll(use payroll)
Data must be "roughly true"
Data must be "roughly true"
eg HR got 1900 staff, A/C got 3 staff
Labels: csa lab
2:09 PM By bsg1B23
