| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula returns (correctly) a negative value
CELL AE198 displays 15% of cell AE193. My formula in cell AE198 is:
=SUM(AE193*0.15) Whenever the value in cell AE193 is negative, i.e. less than 0.00, this formula currently correctly returns a negative value which I do not want to show, rather whenever this formula (and cell AE193) are negative values, I want the formula in cell AE198 to display 0.00. Whenever cell AE193 and the formula show or return a positive value, then I want the formula to continue correctly displaying whatever that positive value may be. How must I modify my formula in order to achieve this desired objective? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula that returns the sheetname | Excel Discussion (Misc queries) | |||
| FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
| How to type correctly formula in calculated field in a pivot? | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
Threaded Mode
