A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
#DIV/0! instead of total by Melinda
I have a worksheet I am adding the numbers to daily for calculations. Rather than showing the correct amount at the column on the end which averages the...
August 4th, 2004 05:40 PM
by Peo Sjoblom Go to last post
3 190
#Div/01 by jeda67
=(TRUNC(C4)*60+(C4-TRUNC(C4))*100)/(TRUNC(G4)*60+(G4-TRUNC(G4))*100) I have this formula in one of my spreadsheets, the only problem I have is when I don't...
December 15th, 2005 11:27 AM
by Bob Phillips Go to last post
1 106
#DIV/O error by Karen
I have a workbook with several indiv. sheets totalling to one sheet for a dept. total. Columns are set up in weeks with a monthly total column as well. I...
March 30th, 2004 12:28 AM
by Go to last post
2 131
#DIV/O! by painter50
I get this #DIV/O! when I divide two cell that both total 0. These cell will not always be used in the spreadsheet. Is there any way to show the total of...
March 8th, 2010 05:18 AM
by T. Valko Go to last post
5 140
#DIV/O! Error by Chris
I would like to be abe to have the #DIV/O! error show "N/A" when this formula does not find any values to calculate. Due to another program I am using along...
March 17th, 2009 09:42 PM
by T. Valko Go to last post
5 79
#DIVI/0 issue by Kesbutler
I have using the following formula in column Y. =IF(X26="","",IF(X260,X26/P26,IF(X26=0,"-"))) If P26 is zero I need the percent in column Y to show at 100%,...
March 18th, 2009 05:01 PM
by Luke M Go to last post
1 84
#Missing by Shirley
Hi, I am using Hyperion Smart View - similar to excel. The cells have formula which are suppose to be zero amounts, display #Missing, instead of 0 or - ....
August 28th, 2008 10:22 PM
by JLatham Go to last post
1 136
#missing! by Arne Hegefors
Hi! I have a worksheet with several tables. The tables are linked to each other using functions such as LOOKFORROW and others. I want to calculate the...
October 15th, 2008 05:50 PM
by Peo Sjoblom[_2_] Go to last post
2 114
#N/A by MAX
I have a column with 20 rows and I am entering this function =INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,)) in the first row then I copy down till the 20th...
March 22nd, 2009 02:47 PM
by MAX Go to last post
3 89
#N/A by Mona
I ahve this in my cell: =INDEX('Feb Events'!$H$2:$H$350,MATCH($A5&"one",'Feb Events'!$A$2:$A$350&'Feb Events'!$C$2:$C$350,0)) which results in #N/A because...
May 3rd, 2007 12:40 AM
by Max Go to last post
1 129
#N/A by caldog
I am pulling some stat information off the web, into Excel spreadsheet. My problem is there will be at times that a player will not play, and when this...
November 6th, 2006 03:46 AM
by Max Go to last post
5 149
#N/A by Arturo
Surprising Zeros in Charts My model is built. Using #N/A - my chart displays perfectly, zeros suppressed. This formula is what feeds the values in my chart...
May 5th, 2006 05:25 PM
by Miguel Zapico Go to last post
2 80
#N/A by Freddo
Is there any way you can change #N/A to show anything else eg No
May 5th, 2006 04:56 PM
by Kevin Vaughn Go to last post
3 113
#N/A by Steved
Hello from Steved The below formula gives me #N/A if there is no value in the cell. Could you please tell how I can make the cell blank, until a value is...
July 9th, 2004 02:58 AM
by Steved Go to last post
6 203
#N/A by Alicia
Is there a way to convert the answer #N/A to a zero in the worksheet before you print it?
March 22nd, 2004 11:42 PM
by Frank Kabel Go to last post
6 116
#N/A by John V.
When you enter a function such as median or average which refers to a range of cells that have one or two #N/A's, it does not return a value but returns #N/A. ...
November 6th, 2003 02:51 AM
by Peo Sjoblom Go to last post
1 126
#N/A - "Value not available" by Terry McCoy[_2_]
Folks - I am having a problem with a workbook in Excel 2007. I have what appear to be values, - numbers - in cells, but formulas are returning an #N/A error...
June 30th, 2008 03:03 PM
by Terry McCoy[_2_] Go to last post
6 78
#N/A = FALSE by Jon M
I am trying to get rid of #n/a. Using ISNA OR ISERROR, I Get "FALSE" not the value. The formula I am using is; IF(ISNA(VLOOKUP($A13&C$11,'PC...
August 9th, 2004 04:39 PM
by Dave R. Go to last post
1 117
#N/A coming up in VLOOKUP when visibly the two cells are same by Marcus Bolton
I have tried this a few times and tried to copy and paste but it still keeps coming back with #N/A but if I double click in the cell that I am trying to find...
November 9th, 2006 09:04 AM
by Niek Otten Go to last post
2 108
#N/A conditional format by ellebelle
This error message apears in my spreadsheet alot. #N/A I would like to do a conditional format, so that if a cell equals #N/A then it will grey out the...
February 3rd, 2006 06:13 PM
by bpeltzer Go to last post
1 305
Post New Thread


Display Options
Showing threads 141 to 160 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.