Need help with an IF formula
 

I am trying to put a worksheet together for a client that I need help with.
The objective is to have all of the calculations set up for the client so
that they should only have to fill out one column and the rest of the
worksheet will automatically calculate. I am having a problem with one of
the formulas. The formula I want is if cell j20 is greater than zero, then
(j20-134.62)*10%.

If I just put in the (j20-134.62)*10% formula then the it is showing a
negative amount for the rows that have yet to filled out.

Example of what I want it to look like:

7/30/08 500.00 36.54 ((500.00-134.62)x10%)

Now if I prefill out the calculation for August, I get this:

8/1/08 0.00 -13.46

I don't want it to show a negative amount, it shouldn't go below 0.

Can anyone help? I realize I probably made this a lot more confusing than
it should be. If you could help, I would really appreciate it.








--
Thank You,
Wendy

Need help with an IF formula
 

Hi Wendy
Do you mean something like:
=IF(((j20-134.62)*0.10)<0,"",((j20-134.62)*0.10))

Regards
Michael M

"Wendy" wrote:

I am trying to put a worksheet together for a client that I need help with.
The objective is to have all of the calculations set up for the client so
that they should only have to fill out one column and the rest of the
worksheet will automatically calculate. I am having a problem with one of
the formulas. The formula I want is if cell j20 is greater than zero, then
(j20-134.62)*10%.

If I just put in the (j20-134.62)*10% formula then the it is showing a
negative amount for the rows that have yet to filled out.

Example of what I want it to look like:

7/30/08 500.00 36.54 ((500.00-134.62)x10%)

Now if I prefill out the calculation for August, I get this:

8/1/08 0.00 -13.46

I don't want it to show a negative amount, it shouldn't go below 0.

Can anyone help? I realize I probably made this a lot more confusing than
it should be. If you could help, I would really appreciate it.








--
Thank You,
Wendy

Need help with an IF formula
 

Maybe:
=if(j20=0,"",(j20-134.62)*10%)
or
=max(0,(j20-134.62)*10%)


Wendy wrote:

I am trying to put a worksheet together for a client that I need help with.
The objective is to have all of the calculations set up for the client so
that they should only have to fill out one column and the rest of the
worksheet will automatically calculate. I am having a problem with one of
the formulas. The formula I want is if cell j20 is greater than zero, then
(j20-134.62)*10%.

If I just put in the (j20-134.62)*10% formula then the it is showing a
negative amount for the rows that have yet to filled out.

Example of what I want it to look like:

7/30/08 500.00 36.54 ((500.00-134.62)x10%)

Now if I prefill out the calculation for August, I get this:

8/1/08 0.00 -13.46

I don't want it to show a negative amount, it shouldn't go below 0.

Can anyone help? I realize I probably made this a lot more confusing than
it should be. If you could help, I would really appreciate it.

--
Thank You,
Wendy

--

Dave Peterson

Need help with an IF formula
 

Hi

A third way:

=(J200)*(j20-134.62)*0.1


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Wendy" wrote in message
...
I am trying to put a worksheet together for a client that I need help with.
The objective is to have all of the calculations set up for the client so
that they should only have to fill out one column and the rest of the
worksheet will automatically calculate. I am having a problem with one of
the formulas. The formula I want is if cell j20 is greater than zero,
then
(j20-134.62)*10%.

If I just put in the (j20-134.62)*10% formula then the it is showing a
negative amount for the rows that have yet to filled out.

Example of what I want it to look like:

7/30/08 500.00 36.54 ((500.00-134.62)x10%)

Now if I prefill out the calculation for August, I get this:

8/1/08 0.00 -13.46

I don't want it to show a negative amount, it shouldn't go below 0.

Can anyone help? I realize I probably made this a lot more confusing than
it should be. If you could help, I would really appreciate it.








--
Thank You,
Wendy