| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display negative numbers as zero
can i display a negative number as a zero?
thus if my formula reads: if(a4a5, a2, a4-a2) but a4-a2 cannot equal a negative number? lowest it can be is zero. this formula appears on multiple workbooks, thus it cannot just be if(a4a5, a2,0). thnaks. -- Andrea |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display negative numbers as zero
maybe...
=if(a4a5, a2, max(0,a4-a2)) Andrea wrote: can i display a negative number as a zero? thus if my formula reads: if(a4a5, a2, a4-a2) but a4-a2 cannot equal a negative number? lowest it can be is zero. this formula appears on multiple workbooks, thus it cannot just be if(a4a5, a2,0). thnaks. -- Andrea -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display negative numbers as zero
Hi Andrea,
I don't understand the text of you question, but I do understand the heading: "display negative values as zero". Format |Cells|Number tab|Custom, in the Type box, enter: 0;"0" -- Kind regards, Niek Otten Microsoft MVP - Excel "Andrea" wrote in message ... | can i display a negative number as a zero? | | thus if my formula reads: if(a4a5, a2, a4-a2) but a4-a2 cannot equal a | negative number? lowest it can be is zero. this formula appears on multiple | workbooks, thus it cannot just be if(a4a5, a2,0). | | thnaks. | | -- | Andrea |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display negative numbers as zero
if(a4a5, a2, max(0, a4-a2))
-- Regards, Luc. "Festina Lente" "Andrea" wrote: can i display a negative number as a zero? thus if my formula reads: if(a4a5, a2, a4-a2) but a4-a2 cannot equal a negative number? lowest it can be is zero. this formula appears on multiple workbooks, thus it cannot just be if(a4a5, a2,0). thnaks. -- Andrea |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display negative results | Excel Worksheet Functions | |||
| Find negative numbers | Excel Discussion (Misc queries) | |||
| how to display numbers in thousands i.e display 10,000 as 10 | Excel Worksheet Functions | |||
| Compare Negative & Positive Numbers | New Users to Excel | |||
| Negative Numbers | Excel Discussion (Misc queries) | |||
Linear Mode
