Help with a function
 

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

Help with a function
 

Not sure but try taking off the unnecessary spaces and equal sign and
try again.

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

Anubis.Ice Wrote:
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?


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

Help with a function
 

Hi Anubis.Ice,

What is it that you want to happen if...or not...?
Is 38.46 multiplied after the subtraction or before?
20%?
Additionally, you are missing some commas, and probably some () too.

Please explain in more detail.

Help with a function
 

=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

Help with a function
 

yo that work man, thanks for that, I been trying to figure that out for
the past two hours. thank again


--
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