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 : New Users Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
#VALUE by Hank in KC
I have a simple spreadsheet in which three columns are used to keep track of an account balance. Column A is withdrawals, B is deposits, C is balance. A...
March 7th, 2008 05:57 AM
by Tyro[_2_] Go to last post
4 409
#VALUE error by Radar
I am using Excel from Office 2007. I transfered a spreadsheet program from a Works spreadsheet, which I had adapted from one supplied with the program. It...
December 22nd, 2007 08:12 PM
by Roger Converse[_2_] Go to last post
2 235
#VALUE! by dwolf[_2_]
Is there a way to hide the "#value!" so it does not show in the cell?
January 12th, 2010 04:37 PM
by Bernard Liengme Go to last post
4 193
#VALUE! Error by DJL
in cell E8 I have this formula: =IF(ISBLANK(D8),"",D8*$B$2) I get the #VALUE! error. Can someone tell me why and how I can correct it. I am just trying to say...
December 24th, 2005 10:38 PM
by Ragdyer Go to last post
7 672
#Value! Error in Nested IF Function by Tom
I have to IF Functions that work independently and I am trying to combine them into one function. My desired end result is either the text "BUY" or...
March 26th, 2009 02:02 AM
by JoeU2004 Go to last post
4 161
#Value! errors by Field8585
I have experienced a problem that I am unable to find a rectification for. When my staff constantly use the space bar to delete an entered in error number and...
February 7th, 2006 10:25 PM
by Dave Peterson Go to last post
1 99
#VALUE! from SUMPRODUCT by gte
I have a problem with SUMPRODUCT. If I use this function: =SUMPRODUCT($I$58:$I$108;OFFSET($H$58;58-ROW();0;51;1)) I get #VALUE! error. But if I...
January 15th, 2008 07:16 PM
by T. Valko Go to last post
8 171
#VALUE! result when using defined name in formula by Tacrier
I am learning how to name cells and use these names. I tried to name a cell in my Summary sheet using the sum of cells in my Detail sheet. When I press...
June 1st, 2010 09:13 PM
by Max Go to last post
1 5,138
#vlaue! by Rao Ratan Singh
Sir, =IF(ISBLANK(E24),"",(DATE(YEAR(E24),MONTH(E24)+3-MOD(MONTH(E24)-1,3),1))) It is returning #value! Due to in e24 which have a conditional formula which is...
January 16th, 2006 02:42 PM
by bpeltzer Go to last post
1 164
$ 500 (Dollar Five Hundred) how do i set up in excell by asghar
I want to set up a formula in excell to display the numiric value in words value
February 27th, 2007 04:35 PM
by Bernard Liengme Go to last post
3 159
$ in functions by bgraczyk
What does the "$" do in a function? --- Message posted from http://www.ExcelForum.com/
September 8th, 2004 09:52 PM
by David McRitchie Go to last post
8 184
% calculation by Meggen
I have a database with names (a1) dates(d1) months (e1) and dates (g1) (other colums are irrelevant like job descriptions) We have several daily events and I...
July 6th, 2005 02:34 PM
by Barb R. Go to last post
1 190
% pain by Danny J
I am being silly but is there a way of setting a workshhet so that when I type in 4.9 in a percentage formatted cell it does not appear as 490%? I suppose I...
November 19th, 2004 11:16 PM
by Danny J Go to last post
3 196
& IN EXCEL HEADER AND FOOTER by Matt
Hi everbody, How do I put an & in an excel header and footer? It seems to disappear. Thanks! Matt.
August 17th, 2004 02:05 PM
by Frank Kabel Go to last post
1 327
& in footer by Craig
How do I make an & appear in a footer.
August 16th, 2006 12:48 AM
by Max Go to last post
2 102
" and > by lschuh
Can someone tell me what does the &quot and &gt mean in most of the posts that I am looking at? These are appearing in all the answers within the...
June 13th, 2005 06:47 PM
by Chip Pearson Go to last post
1 173
"Can't find macro" error by JoAnn
I have a simple macro that executes the following: Sub SAVE_Quit() ActiveWorkbook.Save Application.Quit End Sub I assigned it to a toolbar button...
(Multi-page thread 1 2)
April 14th, 2008 05:06 PM
by JoAnn Go to last post
11 340
"Cannot shift objects off sheet" - what? by Tinde
Hi, I have quite a big file (several linked worksheets and charts). I have used group function earlier and grouping has worked fine. Now when I try to open...
March 30th, 2007 02:37 AM
by Dave Peterson Go to last post
2 150
"Connect to MS Office Online" doesn't work. How do I fix? by Linda
When I click Connect to Microsoft Office Online, nothing happens. I have Microsoft Explorer turned on, so I know I have a connection. Maybe I've lost the URL...
December 13th, 2005 10:42 PM
by Linda Go to last post
0 227
"Control" plus "click" doesn't allow me to select multiple cells by Ken Cooke
In excel (and a number of other applications) holding down control and clicking with the mouse doesn't let me select multiple cells, photos, files etc.I...
September 25th, 2006 04:46 PM
by Ken Cooke Go to last post
0 95
Post New Thread


Display Options
Showing threads 21 to 40 of 13737
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:15 AM.


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