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 / Thread Starter Reverse Sort Order Last Post Replies Views
Showing Error when going to pass a function like this by Brahmananda Mohanty
=IF(C2=1,"Ten",IF(C2=2,"Twenty",IF(C2=3,"Thirty",IF(C2=4,"Forty",IF(C2=5,"Fifty",IF(C2=6,"Sixty",IF(C2=7,"Seventy",IF(C2=8,"Eight",if(c2=9,"Nine",0)))))))) why...
May 6th, 2007 07:50 AM
by T. Valko Go to last post
1 99
Can I transpose data from rows to cols with a formula not pivot ta by BrainDead
Hi All I have data listed in rows that I want to display in columns which will then be used in another program and I can't use a pivot table. ...
June 3rd, 2010 10:09 PM
by Herbert Seidenberg Go to last post
1 1,095
Conditional Formatting that will display conditional data by BrainFart
I would like to be able to enter a number into a cell and then have that number automatically change to a different number. Example: I would like to be able...
September 13th, 2005 05:45 PM
by Gary''s Student Go to last post
1 130
post positive sum as a negative? help! by Brainless_in_Boston
Good ole microsoft... I have entered 2 positiive numbers in sequential cells in a column, however, I want to display their (positive) sum as a negative, so I...
March 24th, 2006 09:19 AM
by Marijus Go to last post
1 147
search for help? it sucks by Brainless_in_Boston
#1 I don't want to "Select a Discussion Group" (accordingly, since I MUST, I will post to a bunch of discussion groups and hope against all hope that...
March 23rd, 2006 05:52 PM
by Biff Go to last post
1 80
use COUNTIF to total BOLD TEXT?? by Brainless_in_Boston
I am auditing a list of subscribers (for their Dental benefit), and highlighted (in BOLD text) the ones I need to research. I want to count the cells with BOLD...
March 22nd, 2006 08:00 PM
by Brainless_in_Boston Go to last post
4 92
IMPORTING DATA MY NUMBERS ARE NOT READ AS NUMBERS by BRAINOC
WHEN COPYING DATA FROM A SPREADSHEET EMAILED TO ME AND PASTING THAT SAME DATA INTO A DATABASE IN A MASTER SPREADSHEET THAT USES A V LOOKUP FUNCTION TO FIND...
July 9th, 2008 01:24 AM
by pshepard Go to last post
2 68
Hide #Value! by brainstewn
=IF(H38=0,"",(($C59+C60)/$H38)) I've read the techniques for hiding the #Value! when empty but need help. I tried doing it with ideas in the forum but it's...
October 17th, 2009 03:52 PM
by Kassie Go to last post
3 117
July 11th, 2009 04:25 PM
by Gord Dibben Go to last post
2 145
Need help with a forcasting type problem by Brake-Man2008
I am trying to have excel do a few automatic calculations for me. In the problem I am trying to solve I have the following: Given: Month (day...
December 2nd, 2008 09:49 PM
by Brake-Man2008 Go to last post
5 72
What does Excel's RAND function really do by Brakeshoe
I am trying to match a clients spreadsheet where they are using RAND() to generate values for the cumulative inverse standard normal distribution. According...
November 13th, 2007 02:38 PM
by Jerry W. Lewis Go to last post
4 177
AVERAGE (But only IF) by Brampton76
I have 4 named Columns, for simplicity they a Code, Red, Blue and Green. In the Code Column are the numbers 1,2, or 3 and are random. The Red, Blue and...
February 8th, 2008 08:48 PM
by T. Valko Go to last post
6 50
Vlookup returns value in the adjacent row by Bran
I am trying to use the vlookup function and it is returning the value in the cell in the row just above the appropriate value in the table I am...
July 19th, 2006 08:28 PM
by Tom Hutchins Go to last post
2 62
Always show data from "Yesterdays" date from another worksheet by bran100
I have two worksheets Worksheet 1 has a summary of data that is gathered from worksheet 2 (detailed data) Worksheet 2 has the date in the A column and data...
March 14th, 2007 08:45 PM
by bran100 Go to last post
2 72
How do I prevent entering duplicate numbers in an excel worksheet by Bran5956
I have a lot of bill laden numbers I need to keep track of in an excel worksheet for accounts payable and I want to prevent entering duplicate numbers. Is...
October 23rd, 2006 06:03 PM
by Jim Thomlinson Go to last post
1 54
"#N/A" -- can I convert to a "0" (zero)? by Branchie
I have just learned to pull query data into a spreadsheet through VLOOKUP. However some years have no data in the query and it returns an #N/A in the cell. ...
December 7th, 2006 10:06 PM
by Gord Dibben Go to last post
2 75
Counting # of Formulas in a column with formulas and entered data by Brand
My spread sheet consists of approximately 550 rows and growing. Calculations are calculated as data is entered by hand from left to right. For instance,...
October 10th, 2009 01:01 PM
by Gary''s Student Go to last post
1 154
Section Breaks by Brand33
Is there a function for section breaks in Excel as there is in Word that gives you the ability to changes fonts, margin sizes, etc. in the new section?
February 9th, 2004 05:33 PM
by JE McGimpsey Go to last post
2 385
How do i Use actual number displayed? by BrandenKilgore
I'm working on a spreadsheet with a lot of referenced formulas. I have it set to where, for example, .08*19 displays the answer "2" because I have it with no...
August 10th, 2005 09:29 PM
by Bernie Deitrick Go to last post
2 219
Calculating tvl time in Excel 2000 Rev.9.2720 by Brandi
Can someone please help? On timesheet in Excel, there are 4 columns: Travel Time to site Arrival time at site Departure time from site Return Travel time If...
January 27th, 2005 10:15 PM
by Brandi Go to last post
5 438
Post New Thread


Display Options
Showing threads 10021 to 10040 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 10:59 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.