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 Last Post Reverse Sort Order Replies Views
ISERROR function by Gotroots
I want to add in ISERROR function into the following formula =(D6-C6)-F6 Here is my attempt: =(IFERROR(D6-C6)-F6)),"",(D6-C6)-F6 Thank you
January 6th, 2010 02:21 PM
by Ms-Exl-Learner Go to last post
2 86
VLOOKUP/HLOOKUP Query by Terry Bennett
Hope I can explain this clearly enough . I have c 50 branches of a retail outlet, each of which have a bank account that is used on a daily basis. The...
January 6th, 2010 01:26 PM
by Terry Bennett Go to last post
0 127
Display result depending on value entered by Gotroots
I want a quick way to enter a time in a cell. example: F5 can either be 00:45 or 00:30 If the value 1 is entered into G5 then F5 will return 00:45 and if...
January 6th, 2010 01:21 PM
by trip_to_tokyo[_3_] Go to last post
3 196
Working with time calculations by Gotroots
When working with time calculations I am finding it difficuult to subtract a specified time. Example: In: 8:46:00 AM C5 Out: 5:17:00 PM D5 Break: :45...
January 6th, 2010 11:52 AM
by trip_to_tokyo[_3_] Go to last post
3 171
Excel worksheets won't all print by angie
I have an inventory that starts with a summary page and is followed up by the individual inventory types. I have always been able to print all the...
January 6th, 2010 07:29 AM
by ryguy7272 Go to last post
1 168
Linking data from the Internet by Doug Sanders[_2_]
Please guide me if I'm in the wrong group, I don't want to cross post unnecessarily. I want to modify a working Spread sheet to pull stock values from the...
January 6th, 2010 07:22 AM
by ryguy7272 Go to last post
3 214
How can I lookup when match has more than one value? by Paulynn
Hi, I'm doing a Vlookup match function and it works, but what I want to do is get the second match of a...
January 6th, 2010 05:54 AM
by Jacob Skaria Go to last post
2 154
sumif wildcard criteria by craig
I cant seem to get the wild card to work in a simple SUMIF My criteria data is as follows 579910001 569410001 538610001 .......Etc The criteria I want use is...
January 6th, 2010 04:22 AM
by T. Valko Go to last post
1 142
If - Then question by Ksean
How would I write a formula to handle this problem? If the value in cell D20 is ‘U18’ then the result in cell D6 is a ‘0’ however if the value in D20...
January 6th, 2010 03:59 AM
by T. Valko Go to last post
3 128
Formatting Numbers as Text!!! by computerlady 143
I have a spreadsheet that contains the following data: Date Account...
January 6th, 2010 03:52 AM
by Sheeloo Go to last post
4 117
Help Formating Numbers to Text by klafert
I have a spreadsheet that contains the following data: Date Account...
January 6th, 2010 03:41 AM
by Billy Liddel Go to last post
1 95
Is 4th January 2010 = Week 2?? by nginhong
Dear all, Happy New Year! I am using the following formula to show week number ="WEEK " & WEEKNUM(NOW(),1) However I notice today 4th January 2010 turns out...
January 6th, 2010 02:23 AM
by Ron Rosenfeld Go to last post
4 147
Date to Day by Raz
1. if I add one to the Date it gives me date of the next day. How do I do it for the days? Example: 04-Jan in cell A1, on A2 I have =A1+1 gives me 05-Jan if...
January 6th, 2010 01:17 AM
by Gord Dibben Go to last post
2 137
sumif wildcard criteria by craig
Hi, I cant seem to get the wildcard to work with a simple sumif I have a range of numbers as below 597910001 587910001 567910001 I wish to sumif on the last...
January 6th, 2010 01:15 AM
by T. Valko Go to last post
1 103
Excel Worksheet does not save by Work related
I worked on the spreadsheet the other day, deleting some lines and merging some cells and I saved it. But once I close and reopen it or send it to someone,...
January 6th, 2010 01:08 AM
by Gord Dibben Go to last post
2 126
Problems with ngs by T. Valko
There's seems to be a problem with the ngs (surprise!). It looks like no posts are making it through to the MS web interface which explains why we are seeing...
January 6th, 2010 01:05 AM
by T. Valko Go to last post
2 89
Creating dynamic ranges which are named. by U0107
In Office 2007, I want to create a named range on one tab and use it as the list in data validation in another tab. Imagine the following: 1) one work book...
January 6th, 2010 12:46 AM
by T. Valko Go to last post
1 148
Date formulas by Construk
Hi, I'm doing a timesheet. The month begin on the 21 and end on 20th of each month (don't ask). It'easy to set a listmenu to choose the month, have the first...
January 6th, 2010 12:26 AM
by Teethless mama Go to last post
2 82
Logical Test: Text Against Number by rslaughter5
Can anyone provide insight into how Excel treats this type of test? For example, why does Excel return TRUE when we have ="a"2 but FALSE when ="a"2 (or any...
January 6th, 2010 12:23 AM
by RyGuy Go to last post
2 121
Using "Verifiers" by R.Best
I have created what I call "Verifier" formulas in a large workbook to ensure that my data, as well as my formulas are all acting in the way I intended, I...
January 6th, 2010 12:06 AM
by R.Best[_2_] Go to last post
2 95
Post New Thread


Display Options
Showing threads 4121 to 4140 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 09:31 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.