| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
make negative number value to zero
6 8 -2.00 Can someone tell me instead of the negative -2. How do I make the value equal to 0. -- india0693 ------------------------------------------------------------------------ india0693's Profile: http://www.excelforum.com/member.php...o&userid=25663 View this thread: http://www.excelforum.com/showthread...hreadid=390804 |
|
#2
|
|||
|
|||
|
If your numbers are in A1 to A3, put the below formula in B1 and copy down... =IF(A1<0,0,A1) HTH Ola Sandström -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=390804 |
|
#3
|
|||
|
|||
|
when I enter that function in cell A3....it gave me the wrong answer. In cell A3, it gave me (3) as the answer.....I used this formula: If your numbers are in A1=3 to A2=8, =IF(A1<0,0,A1) -I am looking for a way to calculate only zero instead of going below 0.- example: 3 8 -5 (instead of -5, I am looking for a way to make it calculate to the number zero) However, if switch around the correct answer will be positive 5... ???But how do I make the answer show the number zero if it becomes (-5)???? -- india0693 ------------------------------------------------------------------------ india0693's Profile: http://www.excelforum.com/member.php...o&userid=25663 View this thread: http://www.excelforum.com/showthread...hreadid=390804 |
|
#4
|
|||
|
|||
|
=MAX(your formula,0)
-- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "india0693" wrote in message ... 6 8 -2.00 Can someone tell me instead of the negative -2. How do I make the value equal to 0. -- india0693 ------------------------------------------------------------------------ india0693's Profile: http://www.excelforum.com/member.php...o&userid=25663 View this thread: http://www.excelforum.com/showthread...hreadid=390804 |
|
#5
|
|||
|
|||
|
Sorry, I misunderstood your question. This is one way: =IF(A1-A2<0,0,A1-A2) Ola Sandström Here's a short video of the IF-function: http://www.auditexcel.co.za/docs2/IF.wmv -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=390804 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a cell a certain color dependent on number value? | Excel Discussion (Misc queries) | |||
| How can I make a number e.g. "14" appear as a word e.g. "fourteen. | Excel Worksheet Functions | |||
| Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| How can I make autofilter show the filtered number of rows | Excel Worksheet Functions | |||
Linear Mode
