| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
As Max said, but inserting your example
=MAX(0,SUM(A1:A2)) -- Regards Roger Govier "india0693" wrote in message ... 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=390811 |
| 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 | |||
Hybrid Mode
