Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank if sum is less than 0
I'm trying to get a blank (or even a 0) if the sum is 0 or less.
Here's what I have in the cell SUM(D14-E14) I have answers that go negative [-2, -5, etc] but I'm trying to just see a number in the cell only if the value is greater than 0. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank if sum is less than 0
Then you want:
=if(d14<e14,0,d14-e14) You don't need the Sum function to do arithmetic. You only need when you are summing numbers. Regards, Fred. "freds" wrote in message ... I'm trying to get a blank (or even a 0) if the sum is 0 or less. Here's what I have in the cell SUM(D14-E14) I have answers that go negative [-2, -5, etc] but I'm trying to just see a number in the cell only if the value is greater than 0. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank if sum is less than 0
Freds --
=IF(SUM(D14-E14)0,SUM(D14-E14),"") Should do the trick for you. HTH "freds" wrote: I'm trying to get a blank (or even a 0) if the sum is 0 or less. Here's what I have in the cell SUM(D14-E14) I have answers that go negative [-2, -5, etc] but I'm trying to just see a number in the cell only if the value is greater than 0. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank if sum is less than 0
=IF(SUM(D14-E14)<0,"",SUM(D14-E14))
-- Gary''s Student - gsnu200780 "freds" wrote: I'm trying to get a blank (or even a 0) if the sum is 0 or less. Here's what I have in the cell SUM(D14-E14) I have answers that go negative [-2, -5, etc] but I'm trying to just see a number in the cell only if the value is greater than 0. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank if sum is less than 0
On Apr 21, 10:12*am, "Fred Smith" wrote:
Then you want: =if(d14<e14,0,d14-e14) You don't need the Sum function to do arithmetic. You only need when you are summing numbers. Regards, Fred. "freds" wrote in message ... I'm trying to get a blank (or even a 0) if the sum is 0 or less. Here's what I have in the cell *SUM(D14-E14) I have answers that go negative [-2, -5, etc] but I'm trying to just see a number in the cell only if the value is greater than 0. Thanks- Hide quoted text - - Show quoted text - =max(D14-E14,0) but you might like this better: =max (sum(d14,-e14), 0) The coma is missing from your formula although it may not make any difference, and if you want nothing instead of a 0 =IF(D4- E4)<=0,"",D4-E4). ed |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank if sum is less than 0
All-
Thanks for your help. I tried them all and the formula below worked best for what I needed to do [ all the formulas worked, but this one was a closer match ]. Again, thanks for helping. It is truly appreciated. Freds "Gary''s Student" wrote: =IF(SUM(D14-E14)<0,"",SUM(D14-E14)) -- Gary''s Student - gsnu200780 "freds" wrote: I'm trying to get a blank (or even a 0) if the sum is 0 or less. Here's what I have in the cell SUM(D14-E14) I have answers that go negative [-2, -5, etc] but I'm trying to just see a number in the cell only if the value is greater than 0. Thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank if sum is less than 0
On Monday, April 21, 2008 at 4:16:01 PM UTC+1, pdberger wrote:
Freds -- =IF(SUM(D14-E14)0,SUM(D14-E14),"") Should do the trick for you. HTH "freds" wrote: I'm trying to get a blank (or even a 0) if the sum is 0 or less. Here's what I have in the cell SUM(D14-E14) I have answers that go negative [-2, -5, etc] but I'm trying to just see a number in the cell only if the value is greater than 0. Thanks Perfect! Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
How do I make a blank cell with a date format blank? | Excel Worksheet Functions |