=if((f4-d4*38.46) 0, 20% * (f4-d4 *38.46),0)

or
=max(0,20% * (f4-d4 *38.46))

--
Regards,
Tom Ogilvy


"Anubis.Ice" wrote
in message ...

Hey guys, Im new here. I need help with a project that I'm working at
for school. I'm having problems on getting the "IF Function" right.

The book said" IF(Gross Pay - Dependents * 38.46 ) 0, =20% * (Gross
Pay - Dependents * 38.46 ), = 0 "

The way I wrote down the formula was " =if((f4-d4 * 38.46) 0, =20% *
(f4-d4
* 38.46 ), = 0) "

If i read down that way I just get a error that incorrect, I always
try
" =if(f4-d4*38.46) 0, =20% * (f4-d4 *38.46), = 0 " still give me a
error.

I hope if there anyone can help me with this?


--
Anubis.Ice
------------------------------------------------------------------------
Anubis.Ice's Profile:
http://www.excelforum.com/member.php...o&userid=33097
View this thread: http://www.excelforum.com/showthread...hreadid=529071