| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
output negative result will show zero value
hi community
how can i create a formula that show this output.... worksheet A worksheet B worksheet C worksheet A - worksheet B, if output is negative, worksheet C will show zero value but worksheet A - worksheet B, if output is positive, worksheet C will show its value as usual can anybody kindly guide me on this... thanks community for the assistance :) -- oldLearner57 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
output negative result will show zero value
I wonder if the following is what you are looking for. In C1:
=max(0, A1 - B1) On Apr 22, 5:09*pm, oldLearner57 wrote: hi community how can i create a formula that show this output.... worksheet A worksheet B worksheet C worksheet A - worksheet B, if output is negative, worksheet C will show zero value but worksheet A - worksheet B, if output is positive, worksheet C will show its value as usual can anybody kindly guide me on this... thanks community for the assistance :) -- oldLearner57 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
output negative result will show zero value
My best guess...
=MAX(Sheet1!A1-Sheet2!A1,0) -- Biff Microsoft Excel MVP "oldLearner57" wrote in message ... hi community how can i create a formula that show this output.... worksheet A worksheet B worksheet C worksheet A - worksheet B, if output is negative, worksheet C will show zero value but worksheet A - worksheet B, if output is positive, worksheet C will show its value as usual can anybody kindly guide me on this... thanks community for the assistance :) -- oldLearner57 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
output negative result will show zero value
On Tue, 22 Apr 2008 18:09:00 -0700, oldLearner57
wrote: hi community how can i create a formula that show this output.... worksheet A worksheet B worksheet C worksheet A - worksheet B, if output is negative, worksheet C will show zero value but worksheet A - worksheet B, if output is positive, worksheet C will show its value as usual can anybody kindly guide me on this... thanks community for the assistance :) When you write "show", I am assuming you mean "display", but that you still want the correct result stored in the cell. That being the case, custom format the cell something like: General;\0;General The second section is for negative numbers, and the format will have it display a literal "0" if the number is negative. The true result will still be in the cell, however. To custom format, right click on the cell and select "Format Cells" from the drop down menu. Then select the Number tab; Custom and Type: the above --ron |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
output negative result will show zero value
it can be done like this =if(worksheet A - worksheet B < 0,0,worksheet A -
worksheet B) "oldLearner57" wrote: hi community how can i create a formula that show this output.... worksheet A worksheet B worksheet C worksheet A - worksheet B, if output is negative, worksheet C will show zero value but worksheet A - worksheet B, if output is positive, worksheet C will show its value as usual can anybody kindly guide me on this... thanks community for the assistance :) -- oldLearner57 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I output result of formula to another cell? | Excel Discussion (Misc queries) | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| How do you get a conditional output to show in color | Excel Discussion (Misc queries) | |||
| with formulas that show negative results I want to show zero inste | Excel Discussion (Misc queries) | |||
| HOW CAN I SHOW OUTPUT IN FEET INCH FORMAT | New Users to Excel | |||
Linear Mode
