software

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 quot;IF Functionquot; right.

The book saidquot; IF(Gross Pay - Dependents * 38.46 ) gt; 0, =20% * (Gross
Pay - Dependents * 38.46 ), = 0 quot;

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

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

I hope if there anyone can help me with this?--
Anubis.Ice
------------------------------------------------------------------------
Anubis.Ice's Profile: www.excelforum.com/member.php...oamp;userid=33097
View this thread: www.excelforum.com/showthread...hreadid=529071
Not sure but try taking off the unnecessary spaces and equal sign and
try again.

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

Anubis.Ice Wrote:
gt; Hey guys, Im new here. I need help with a project that I'm working at
gt; for school. I'm having problems on getting the quot;IF Functionquot; right.
gt;
gt; The book saidquot; IF(Gross Pay - Dependents * 38.46 ) gt; 0, =20% * (Gross
gt; Pay - Dependents * 38.46 ), = 0 quot;
gt;
gt; The way I wrote down the formula was quot; =if((f4-d4 * 38.46) gt; 0, =20% *
gt; (f4-d4
gt; * 38.46 ), = 0) quot;
gt;
gt; If i read down that way I just get a error that incorrect, I always
gt; try
gt; quot; =if(f4-d4*38.46) gt; 0, =20% * (f4-d4 *38.46), = 0 quot; still give me a
gt; error.
gt;
gt; I hope if there anyone can help me with this?--
Infinity
------------------------------------------------------------------------
Infinity's Profile: www.excelforum.com/member.php...oamp;userid=32725
View this thread: www.excelforum.com/showthread...hreadid=529071Hi 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.

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

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

--
Regards,
Tom Ogilvyquot;Anubis.Icequot; gt; wrote
in message ...
gt;
gt; Hey guys, Im new here. I need help with a project that I'm working at
gt; for school. I'm having problems on getting the quot;IF Functionquot; right.
gt;
gt; The book saidquot; IF(Gross Pay - Dependents * 38.46 ) gt; 0, =20% * (Gross
gt; Pay - Dependents * 38.46 ), = 0 quot;
gt;
gt; The way I wrote down the formula was quot; =if((f4-d4 * 38.46) gt; 0, =20% *
gt; (f4-d4
gt; * 38.46 ), = 0) quot;
gt;
gt; If i read down that way I just get a error that incorrect, I always
gt; try
gt; quot; =if(f4-d4*38.46) gt; 0, =20% * (f4-d4 *38.46), = 0 quot; still give me a
gt; error.
gt;
gt; I hope if there anyone can help me with this?
gt;
gt;
gt; --
gt; Anubis.Ice
gt; ------------------------------------------------------------------------
gt; Anubis.Ice's Profile:
www.excelforum.com/member.php...oamp;userid=33097
gt; View this thread: www.excelforum.com/showthread...hreadid=529071
gt;

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: www.excelforum.com/member.php...oamp;userid=33097
View this thread: www.excelforum.com/showthread...hreadid=529071