Negative
in [General]
|
From: Jon on 30 Apr 2010 09:29 no joy....I have an actual value show with copy/ paste special Values but when i put in =IF('April 15'!E26<0,0,'April 15'!E26) it comes up blank.......sigh thanks -- Jon "Sean Timmons" wrote: > OK, copy/ paste special Values to see the actual value, then undo it so you > don't lose the formula. If there's a negative value in there normally, > > =IF('April 15'!E26<0,0,'April 15'!E26) > > Should work fine... > > "Jon" wrote: > > > this is a summary page from a months worth of data ='April 15'!E26 is what > > appears in the formula bar. > > thanks > > -- > > Jon > > > > > > "Sean Timmons" wrote: > > > > > If you look at the Formula bar, is the number 0 in there? > > > > > > Ensure your Cell Format is set as Number, 0. > > > > > > "Jon" wrote: > > > > > > > I've tried that and the cell goes blank > > > > -- > > > > Jon > > > > > > > > > > > > "BSc Chem Eng Rick" wrote: > > > > > > > > > Hi Jon, > > > > > > > > > > Use this formula: > > > > > =IF("Cell Reference"<0,0,"Cell Reference") > > > > > -- > > > > > If this helps, please click "Yes" > > > > > <><><><><><><><><><><> > > > > > > > > > > > > > > > "Jon" wrote: > > > > > > > > > > > I have a summary sheet for a month's worth of data and I need the negative's > > > > > > that appear to come out as zero's > > > > > > -- > > > > > > Jon
From: Jon on 30 Apr 2010 09:45 Office button??? -- Jon "BSc Chem Eng Rick" wrote: > The problem may be that your sheet shows zeros as blanks, do the following > Office button --> Excel Options --> Advanced --> Display options for this > worksheet --> Show a zero in cells that have zero value. > -- > If this helps, please click "Yes" > <><><><><><><><><><><> > > > "Jon" wrote: > > > this is a summary page from a months worth of data ='April 15'!E26 is what > > appears in the formula bar. > > thanks > > -- > > Jon > > > > > > "Sean Timmons" wrote: > > > > > If you look at the Formula bar, is the number 0 in there? > > > > > > Ensure your Cell Format is set as Number, 0. > > > > > > "Jon" wrote: > > > > > > > I've tried that and the cell goes blank > > > > -- > > > > Jon > > > > > > > > > > > > "BSc Chem Eng Rick" wrote: > > > > > > > > > Hi Jon, > > > > > > > > > > Use this formula: > > > > > =IF("Cell Reference"<0,0,"Cell Reference") > > > > > -- > > > > > If this helps, please click "Yes" > > > > > <><><><><><><><><><><> > > > > > > > > > > > > > > > "Jon" wrote: > > > > > > > > > > > I have a summary sheet for a month's worth of data and I need the negative's > > > > > > that appear to come out as zero's > > > > > > -- > > > > > > Jon
From: Jon on 30 Apr 2010 09:51 Thanks, I've tried these and they just come back blank. In other cells when they are zero's they come back as a zero value. -- Jon "Bernard Liengme" wrote: > Hopefully your numbers are generated by formulas. Then you can modify them > to read > =IF(your_formula<0,0,your_formula) > or > =IF(your_forumula,your_formula,0) > or > your_formula*(your_formula>0) > > Or, if it is only for appearance and no further calculations are involved, > use a custom format like > #,"0","0" > > best wishes > -- > Bernard Liengme > Microsoft Excel MVP > http://people.stfx.ca/bliengme > > "Jon" <Jon(a)discussions.microsoft.com> wrote in message > news:93F9DED9-A9E4-4A51-A632-DC3C6ECFEEEE(a)microsoft.com... > > I have a summary sheet for a month's worth of data and I need the > > negative's > > that appear to come out as zero's > > -- > > Jon > > . >
From: Jon on 30 Apr 2010 10:04 Thanks,...tried that. It fills in all the blanks but still leaves that one cell with a negative number -- Jon "מיכאל (מיקי) אבידן" wrote: > 'Tools' > 'Options...' > 'View' tab. > Micky > > > "Jon" wrote: > > > Office button??? > > -- > > Jon > > > > > > "BSc Chem Eng Rick" wrote: > > > > > The problem may be that your sheet shows zeros as blanks, do the following > > > Office button --> Excel Options --> Advanced --> Display options for this > > > worksheet --> Show a zero in cells that have zero value. > > > -- > > > If this helps, please click "Yes" > > > <><><><><><><><><><><> > > > > > > > > > "Jon" wrote: > > > > > > > this is a summary page from a months worth of data ='April 15'!E26 is what > > > > appears in the formula bar. > > > > thanks > > > > -- > > > > Jon > > > > > > > > > > > > "Sean Timmons" wrote: > > > > > > > > > If you look at the Formula bar, is the number 0 in there? > > > > > > > > > > Ensure your Cell Format is set as Number, 0. > > > > > > > > > > "Jon" wrote: > > > > > > > > > > > I've tried that and the cell goes blank > > > > > > -- > > > > > > Jon > > > > > > > > > > > > > > > > > > "BSc Chem Eng Rick" wrote: > > > > > > > > > > > > > Hi Jon, > > > > > > > > > > > > > > Use this formula: > > > > > > > =IF("Cell Reference"<0,0,"Cell Reference") > > > > > > > -- > > > > > > > If this helps, please click "Yes" > > > > > > > <><><><><><><><><><><> > > > > > > > > > > > > > > > > > > > > > "Jon" wrote: > > > > > > > > > > > > > > > I have a summary sheet for a month's worth of data and I need the negative's > > > > > > > > that appear to come out as zero's > > > > > > > > -- > > > > > > > > Jon
From: Jacob Skaria on 30 Apr 2010 10:22 Jon, I am not sure whether you have tried the suggestion of custom formatting the cells to General;"0";0 (This will display 0 for -ve values and 0's) General;"0";"" (The above will display 0 for -ve values and blank for 0's) -- Jacob (MVP - Excel) "Jon" wrote: > Thanks, I've tried these and they just come back blank. In other cells when > they are zero's they come back as a zero value. > -- > Jon > > > "Bernard Liengme" wrote: > > > Hopefully your numbers are generated by formulas. Then you can modify them > > to read > > =IF(your_formula<0,0,your_formula) > > or > > =IF(your_forumula,your_formula,0) > > or > > your_formula*(your_formula>0) > > > > Or, if it is only for appearance and no further calculations are involved, > > use a custom format like > > #,"0","0" > > > > best wishes > > -- > > Bernard Liengme > > Microsoft Excel MVP > > http://people.stfx.ca/bliengme > > > > "Jon" <Jon(a)discussions.microsoft.com> wrote in message > > news:93F9DED9-A9E4-4A51-A632-DC3C6ECFEEEE(a)microsoft.com... > > > I have a summary sheet for a month's worth of data and I need the > > > negative's > > > that appear to come out as zero's > > > -- > > > Jon > > > > . > >
First
|
Prev
|
Pages: 1 2 3 Prev: automatically change time in sheet 2, 3, and 4. Next: Auto Sizing Charts / Tables |