answersLogoWhite

0

You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.

=IF(A2<0,0,A2)

You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.

=IF(A2<0,0,A2)

You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.

=IF(A2<0,0,A2)

You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.

=IF(A2<0,0,A2)

You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.

=IF(A2<0,0,A2)

You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.

=IF(A2<0,0,A2)

You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.

=IF(A2<0,0,A2)

You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.

=IF(A2<0,0,A2)

You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.

=IF(A2<0,0,A2)

You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.

=IF(A2<0,0,A2)

You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.

=IF(A2<0,0,A2)

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

Does a blank cell in Excel have a numerical value of negative one?

No. It has a value of zero.


How do I add round to a formula in Excel to show no decimal places in Excel?

There is a function called ROUND which you can use to round to zero decimal places. If your number was in cell A2, the formula would be:=ROUND(A2,0)


Is there an Excel spreadsheet formula to find offsetting positive and negative numbers in a column of data?

If you mean you want to find how far the numbers are from zero, whether they are positive or negative, you could use the ABS function. So if the first value was in A2, then in B2 you could enter the following formula and copy it down: =ABS(A2)


Is the overall charge of a formula unit for a compound never zero?

The overall charge of a formula unit for a compound can be zero if the compound is neutral, meaning the positive and negative charges balance out. However, if the compound is an ion or has a net charge, then the overall charge of the formula unit will not be zero.


Why is a cell in Excel not recognized when trying to include it in a formula it reads zero?

There could be lots of reasons, but without seeing the worksheet and formulas, it is difficult to answer.


How do you create an excel formula that divides two cell's but will not do so if the value being divided by is a zero?

Assuming that Excel's default DIV/0! error detection isn't enough for you... You could use the IF() operator to check the value of the divisor, and return something appropriate if it turns out to be zero.


What is a negative?

A negative can be a negative zero. A negative zero is a number below zero. PS:If you are asking the "negative" in Science, I am not sure of the answer.


What is the negative of zero?

There is no negative of zero, nor is there a positive. Zero is no value, hence it has no positive or negative value.


What does negative zero error mean?

There can't be a negative zero. zero is neither negative nor positive.


Is zero a negative number?

No. A negative number is a number below zero, not zero itself.The number zero is neither negative nor positive.


What is zero negative property?

Zero is not negative. It is not positive either.Zero is not negative. It is not positive either.Zero is not negative. It is not positive either.Zero is not negative. It is not positive either.


How do can zero before numericals words in excel?

If you need to start a word or number with a zero just add an apostrophe immediately before the zero like this '0 excel will then display the zero, however the zero is no longer recognised as a number by the software.