|
|
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
|
|
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...
|
|
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...
|
|
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...
|
|
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...
|
|
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...
|
|
3 |
214 |
|
|
|
|
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...
|
|
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...
|
|
3 |
128 |
|
|
|
January 6th, 2010 03:52 AM
by Sheeloo
|
4 |
117 |
|
|
|
|
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...
|
|
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...
|
|
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...
|
|
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,...
|
|
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...
|
|
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...
|
|
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...
|
|
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
|
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...
|
|
2 |
95 |