Posted to microsoft.public.excel.misc
|
|
if formulas
try this site.
http://www.personal-computer-tutor.com/if2.htm
"lestie" wrote:
i need help w/a formula
if hours<= 40, then gross pay=rate*hours, otherwise gross
pay=rate*hours+0.5* rate*(hours-40)
cell b4 rate
cell c4 hours
next
if(gross pay-dependents*38.46)0, then federal tax=20%*(gross
pay-dependents*38.46), otherwisw federal tax=0
cell f4 gross pay
cell d4 dependents
cell i4 fed tax
--
lestie
|