Dear Seniors,
I jus wanna know the excel formula for the the details given below.
If gross salary is greater than 6500 then pf should be 780, and if lesser than 6500 the pf amount should be 12% gross pay.
I need the formula in excel... pls help me out.
I jus wanna know the excel formula for the the details given below.
If gross salary is greater than 6500 then pf should be 780, and if lesser than 6500 the pf amount should be 12% gross pay.
I need the formula in excel... pls help me out.