Percentage Question

G

Guest

In my spreadsheet I calculate the percentage of an over charged amount.
Sometimes its negative or positive. The formula for the over(positive)
amount is =j2/f2. I copy this down the column. This works, but when a
negative amount is calculated, I need to manually change the formula to the
negative column.

What I want to know is there a way to create a statement that will check to
see if there is a positive or negative amount in the formula, and if not,
just to place a zero there.
 

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

Similar Threads

Negative percentage in data verification dropdown list? 2
How do I calculate variance percetage if figures are negative 5
CAGR for short sales using XIRR 3
Help with positive and negative numbers 1
Need Help with a Formula 5
Cause formulae totals to reflect negative and positive amount inpu 7
How do I show negative percentage in a fomula? 1
If, Then statements with a formula 1

Top