Negative
in [General]
|
From: Jon on 30 Apr 2010 09:01 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: Sean Timmons on 30 Apr 2010 09:05 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:16 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: Sean Timmons on 30 Apr 2010 09:20 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: BSc Chem Eng Rick on 30 Apr 2010 09:22 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
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: automatically change time in sheet 2, 3, and 4. Next: Auto Sizing Charts / Tables |