Need help with an IF formula

W

Wendy

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

Michael M

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

Regards
Michael M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top