Totally New to excel i need help please.

with this i have attached a screen shot.

how do i make the Zeros not to show when there are nothing in the other column.

Thank you

with this i have attached a screen shot.

how do i make the Zeros not to show when there are nothing in the other column.

Thank you

- Show Blank instead of Zero
- Show blank instead of #NUM
- Return Blank instead of Zero
- Show blank instead of #N/A
- Show blank instead of #N/A with Vlookup
- Formula to make cell blank instead of zero
- Blank cell instead of zero
- Columns showing numbers instead of letters - also formula required
- Index Match: Show blank instead of #NA for no match
- Code to show blank instead of 0 when there is no value in linked cell?
- Adjusting a formula to return Blank instead of a zero
- How to get array formula to return an empty cell instead of 00-Jan-00
- Return Blank instead of $0.00 in sumifs
- Paste Values To 1st Blank Row Of Column In Different Worksheet
- Format Function Returns . (Dot) Instead Of Zero
- Linking - destination cell shows "0" instead of value in source ce
- Column Headings showing numbers instead of letters
- How can I have a false Vlookup give a blank instead of #N/A?
- Pivot table showed "All" instead of "Multiple items" when using datasource from CSV
- Return desired result based on a condition (to show 0% instead of #div/0)
- When to use SUM(IF()) instead of COUNTBLANK() in Excel
- When to use SUM(IF()) instead of COUNTBLANK() in Excel
- When to use SUM(IF()) instead of COUNTBLANK() in Excel
- Vlookup returning blank for blank instead of 0

I have 5 sheets. I have used the following formula to show Blank instead of Zero in Sheet2.

=IF('Sheet1'!A5+'Sheet1'!A7)="0","",('Sheet1'!A5+'Sheet1'!A7))

Where, in Sheet1, A5 is a value entered and A7=A5+A6

But with this formula I get the value '0.00' in Cell B3 in Sheet2.

Could you help me as to how to get Blank cell instead of Zero in Sheet2 in Cell B3

Thank you all for your kind help.

Marcus

calculations from blank cells then I used =If (B2="","",B2-1), the problem is

that when I make a graphic with my new values, cero appears in the graphic.

"Frank Kabel" wrote:

> Hi

> =IF(B1="","",B1)

>

> "Db1712" wrote:

>

> >

> > I have two cells linked, is there a formatting to return a blank

> > instead of zero when the cell its linked to is empty

> >

> >

> > --

> > Db1712

> > ------------------------------------------------------------------------

> > Db1712's Profile: http://www.excelforum.com/member.php...o&userid=15912

> > View this thread: http://www.excelforum.com/showthread...hreadid=314201

> >

> >

return the resulting text would show blank instead of #N/A?

=INDEX(Schedule!$B$49:$B$102,MATCH("CKT2",Schedule!$C$49:$C$102,FALSE))

This is the formula I have at the moment:

=IF(SUM(A1=0,B1>0),B1-A1,"No Charge?")

A B C

1 0.18 1 0.82

=IF(LEN(VLOOKUP($A12,'FD RUN LIST - MASTER'!$A$12:$N$596,$B$17))=0,"",(VLOOKUP($A12,'FD RUN LIST - MASTER'!$A$12:$N$596,$B$17,FALSE)))

Is there another formula I should use so I get a blank instead of zero?

my spreadsheet is sowing numbers instead of letters in the column headers. anyone know how to change this back?

also need a formula for the following:

I have a figure in C5, and need D5 to show (C5 minus 2.5 percent)

cheers people

How can I modify the following formula to show a blank instead of #NA when no match is found?

another sheet in a workbook. When that is the case, instead of 0,

what can we put in the code to just show a blank as well in the second

sheet? Right now, if the cell is blank, the link cell shows a "0".

Thank you.

I am using Macros to "delete a column and insert a new column by copying the same formulas(sum) and number formats".While doing this, the formula is calculating the sum of blank cells and returning zero(which i do not want to display).if i use the spaces instead of zero to display,it is erasing the formula.can u plz help me out with this.

When i used tools->options->view: unchecked the zeros values ...i cannot really enter a zero value for summing,as well the previous cell which contain zero is also removed.

I have an array formula that takes a value in cell C2, finds any matching values in the range $A$2:$A$30000 and then returns the latest date associated with these values (the dates are in the range $B$2:$B$30000). This works well.

The problem I have is that when a date is not found in the range $B$2:$B$30000 it returns 00-Jan-00. I think this is because of the zero at the end of my formula which returns zero and then my date formatting shows that as 00-Jan-00. I need it to just show an empty cell ("") instead of 00-Jan-00.

I have tried using "" instead of zero (see formula below) but it returns #Value instead of an empty cell.I also want it to return an empty cell ("") if the value in C2 is not found in the range $A$2:$A$30000. Again, it is presently returning 00-Jan-00 in these cases.

Please see attached example spreadsheet.

I have spent a lot of time experimenting with my formula but have not been able to get the result I need.

Any assistance would be greatly appreciated.

Dave

I have created a drop down list with gas, groceries and travel as the categories.

column a is labeled expenses and formatted as currency.

column b is labeled category with the drop down list in each cell.

column d contains each item, gas, groceries and travel on separate rows.

column e will contain the total for each item in column d using "sumifs formula".

If there are no travel expenses, instead of returning $0.00 I want the cell to be blank.

I know how to do this in a simple sum function but sumifs are sumthin else.

I have tried using <> for not equal to and everything else I can think of and I usually get a VALUE error.

how do I get it to be blank instead of $0.00???

Windows XP and Excel 2007

I have a template with data only in column B, with fields going down the rows. I'd like to copy B2, B4, B6...B24 to the next blank row (so the values need to be transposed to a row vs. column) in a Consolidated Workbook.

Here's what I have so far:

VB:Except that the formula above pastes the first value in column B of sheet2, any ideas on how to get it into column A? Worksheets("sheet2").Cells(NextRow, (a / 2)-1) = Cells(a, 2) gives an error.NextRow = Worksheets("Sheet2").Range("A1000").End(xlUp).Row + 1 For a = 2 To 24 Step 2 Worksheets("sheet2").Cells(NextRow, a / 2) = Cells(a, 2) Next aIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Also, instead of sheet2 in the same workbook, I need to paste the data into sheet2 of a different workboook (i.e. Main, located in My Documents.)

Thank you.

when ltoj is less than zero the following code enters a period in the cell instead of zero.

VB:anyone have any ideas?ltoj = 0 Cells(r, 10) = Format(ltoj * 24, "##.##") 'writes data in correct format .....If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Ross

departments annual leave. Each member of the dept has a separate sheet to

record their leave on and we need another one to summarise.

However, when I try and create links from the individual (source) sheets to

the summary (destination) sheet, I get "0" displayed in the cell rather than

what's in the cell (should be displaying a date)

All cells in all sheets are formatted as general.

The in the coordinates row for the columns, it is showing numbers

instead of letters.

How can we get it back to letters?

Thanks,

so that if the lookup item isn't present, I purposely get a "#N/A". Can I

nest an "IF" statement so that if the vlookup returns a "#N/A", I want it to

appear blank instead of getting the "#N/A"? Thanks.

Thanks you!

Option Explicit 'Set Reference to Microsoft ActiveX Data Objects 2.7 Library Const sConnStrP1 = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" Const sConnStrP2 = ";Extensions=asc,csv,tab,txt;Persist Security Info=False" Const sFilter = "CSV File, *.csv" Sub CreatePivotTableFromCSV() Dim sFileName As String Dim sFilePath As String sFileName = Application.GetOpenFilename(sFilter, 1, "Select File", , False) sFilePath = Left(sFileName, InStrRev(sFileName, "")) sFileName = Replace(sFileName, sFilePath, "") TestCSV sFilePath, sFileName End Sub Sub TestCSV(ByVal sFilePath As String, ByVal sFileName As String) Dim cConnection As ADODB.Connection Dim rsRecordset As ADODB.Recordset Dim pcPivotCache As PivotCache Dim ptPivotTable As PivotTable Dim SQL As String Set cConnection = New ADODB.Connection cConnection.Open sConnStrP1 & sFilePath & sConnStrP2 SQL = "SELECT * FROM " & sFileName Set rsRecordset = New ADODB.Recordset Set rsRecordset = cConnection.Execute(SQL) 'Workbooks("Book1.xls").Activate 'For Excel 2003 Use Set pcPivotCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlExternal) 'For Excel 2007 Use 'Set pcPivotCache = ActiveWorkbook.PivotCaches.Create(SourceType:=xlExternal) Set pcPivotCache.Recordset = rsRecordset Set ptPivotTable = pcPivotCache.CreatePivotTable(TableDestination:=Range("B5")) cConnection.Close Set rsRecordset = Nothing Set cConnection = Nothing End Sub

Well so much for being done, if any one can help with the code below, would appreciate.

I am getting the #div/0 error again but elseware on the below code.

=IF(H9="", "", IF(H9="0", "0%", H18/H9))

Is there somthing I can add in here so when h18/h9 = 0 to show 0% instead of #div/0?

1. Start Microsoft Excel and open a new worksheet. ... Unlike other functions such as SUM, COUNTBLANK will accept ... Microsoft Office Excel 2007 â€¢ Microsoft Office Excel 2003

Unlike other functions such as SUM, COUNTBLANK will accept only one range argument, so ... plus (+) sign indicates that the two IF expressions are to be combined in a logical ...

Unlike other functions such as SUM, COUNTBLANK will accept only one range argument, so ... 1. Open TestBook1 and in cell A6 enter SumIf . 2. In cell B6, enter =SUM(IF ...

example

A1: blah

B1: [blank]

=vlookup(A5,A1:B1,2,0)

A5 should be blank and not 0