Worksheet Functions - Page 644

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.

Thread / Thread Starter	Last Post	Replies	Views
calculating only weekdays by Sinkguy1 I need to enter the date for weekdays only across columns in numerous worksheets. How can i get the dates for monday thru fridays only stating with the date...	March 25th, 2009 11:28 PM by Ashish Mathur[_2_]	6	66
QUARTERLY Profit and Loss Statement by DaveNiche I desperately need a blank template of a regular P and L Statement. I can put in the formulas if need be, but I need the line items that would be listed...	March 25th, 2009 10:14 PM by Fred Smith[_4_]	1	68
Rounding up to next dime by Looking for help today[_2_] =IF(FOBSHEET!B102="","",FOBSHEET!B102*67+6.25) The formula above is one I use to take my costs from an FOB worksheet and to create a sell sheet for my sales...	March 25th, 2009 10:11 PM by Fred Smith[_4_]	2	58
How to create an IF function by Cindygirl I have a spreadsheet that contains prices in column A from $15 and up. In another column, i have a formula already set up (=SUM(G6*5)+125) but i want that...	March 25th, 2009 09:56 PM by Mike H	1	50
Selecting file by [email protected] Hi, I have folder contains 10 to 15 excel file. I want a macro that display open dialog and if user selects 3 files or 2 files, then sheet1 of selected files...	March 25th, 2009 09:44 PM by Dave Peterson	1	64
w/s Formula to Automatically Create Two 2-equi-interval Tables ?? by monir Hello; Your help would be greatly appreciated. 1) Given: no. of X values::A2 = 8 (= 30) max. X value::A3 = 1.00 min. X value ::A4 = 0.93 no. of Y... ( 1 2)	March 25th, 2009 09:42 PM by Bernie Deitrick	14	79
Hiding Results when result should read blank by Looking for help today[_2_] I am using the formula below to create a sell sheet for my sales people. This formula takes my fob costs from my fob worksheet and this formula takes the fob...	March 25th, 2009 09:36 PM by Mike H	1	47
Charting % of Instances by Dax Arroway I need a chart that shows a number of times that someone's been through our system. I have a list of names in column B. Some are there once, some are...	March 25th, 2009 09:36 PM by Dax Arroway	3	66
Agrument or if/and statement by Yevonne I have a spreadsheet that has counties in it. For Clarke I need it to put city, for Jackson, Oglethorpe or Madison I need it to put RTZ and for all others is...	March 25th, 2009 09:31 PM by Yevonne	6	63
Combining Two Columns of Data by clk[_2_] Hello. I have a spreadsheet with data in column A and column H. I need to "copy and paste" all data from column A (starting in A3) to Column N (starting at...	March 25th, 2009 09:07 PM by clk[_2_]	4	72
Pivot Table formating by BK523 I have created several pivot tables and used the auto formatting function. I would like to alter the formatting and preserve it for the next time I refresh...	March 25th, 2009 08:46 PM by BK523	2	54
vlookup error by SDMFG 100 A 100A 1000 8000 200 B 200B 2000 8000 300 C 300C 3000 8000 100-1 D 100-1D 4000 4000 100-2 E 100-2E 5000 ...	March 25th, 2009 08:31 PM by Luke M	2	53
live chart title and a scroll bar by msimonson Can someone give me easy, step by step instructions on how to add a live chart title and a scroll bar into a spreadsheet? I have an X-Y Scatter graph and I...	March 25th, 2009 07:12 PM by msimonson	0	82
Comparing dates by Gareth.Evans Hi all thankyou fro you help, i am trying to compare to dates and say weather one is higher then the other. my formulas below work on one worksheet but not...	March 25th, 2009 07:05 PM by Roger Govier[_3_]	3	59
Convertin hours into days, hours and minutes by Jock Common question and I've looked at a number of different answers in the forum. None quite work for me though. I can get the days part ok using INT, its the...	March 25th, 2009 06:32 PM by Sheeloo[_4_]	6	59
I know my password, yet it will not open my workbook by GIB After entering the data, I set a password for the sheet protection. I copied and pasted the data in another file because I wanted to email the sheet to...	March 25th, 2009 06:23 PM by Bernard Liengme[_2_]	1	63
Advanced if function?? by 5tacey 1 Region A B C D ... G 2 Wales 3 3 2 3 3 England 5 4 2 4 4 England 2 4 4 4 Rating 5 England 1 4 5 1 4 6 Scotland 1 ...	March 25th, 2009 05:39 PM by T. Valko	2	75
Lookup with parts of strings by Maniv Dear all This problem is killing my time since long.. Vlookup works only on exact matches or approximate matches. Choosing the TRUE (approximate matches)...	March 25th, 2009 05:31 PM by Maniv	4	57
Vlookup and/or combing data from two worksheets by Tessa HELP! I have two worksheets. One is the Master Account list and the other is the Aging. I have made it so both have the same column headings (Account, Name,...	March 25th, 2009 05:20 PM by Dave Peterson	3	50
conditional formatting by Darrell_Sarrasin via OfficeKB.com I have four different things that produce the same color. basically I have four different styles of terminations and I want the cell to turn red when it sees...	March 25th, 2009 05:18 PM by Jarek Kujawa[_2_]	4	54

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed