Writing formula for excel worksheet
Item Rate1 Rate2 Rate3
A 3 4 6
B 8 5 23
C 56 5 78
Above is my excel sheet.
I want to write some formula so that in every row cell having minimum rate
should come bold. Like For Item A - Rate1(3)
for Item B - Rate2(5)
For Item C - Rate2 (5)
There may be a neater way but this works. Somewhere in you sheet in a cell
type =min(A1:a4), I used L1 Change this to watever range you are trying to
Then select this range and click format - conditional format - cell value -
is equal to
=($L$1) and apply your bold font.
The lowest value in the range will then become bold.
"Gaur...Hotmail Problem Please Help
I am running Exchange 2003 Standard on a Windows 2003 Server. I also have ISA
2000 on the same box. Everything is working fine. The problem I am having is
getting mail out to a hotmail address.
When I send then mail, I see it sits in the Queue for less then a minute
then disappears. It never makes it to the Hotmail address nor do I get any
return errors back in my client indicating the mail never made it to its
On Sun, 13 Nov 2005 15:51:04 -0800, "Kevin Mc" <Kevin
>I am running Exchange 2003 Standard on a Windows 200...help for sql select command !!!
Imagine we have 3 checkBoxes in a search page and 3 boolean fields in
DB table and every checkbox is for one of these fields . In search
page users check every 3 checkBoxes and what i want is that first it
shows the records that every their 3 fields are checked then 2 and
BTW my DB is MS Access.
Please help me !
On Mar 1, 7:17=A0pm, "miladha...@gmail.com" <miladha...@gmail.com>
> Hi Everyone!
> Imagine we have 3 checkBoxes in a search page and 3 boolean fields in
> DB table and every checkbox is for one of these fields . I...Error in Exchange 5.5 Public Folder access via Outlook 2000
We're running Exchange 5.5 SP4 on NT4, with the May 2004 rollup
(841765 - Store.exe and Mdbmsg.dll = 5.5.2658.4)
Outlook 2003 clients can access a shared Public Folders contacts list
fine through the Address Book application, but Outlook 2000 users
Both groups can see and manipulate the actual folder OK, it's just the
Address Book that's not working (either through the Address Book icon,
or through creating a new mail and clicking on the "To" button and
selecting the folder from there).
Outlook 2000 users see a blank list, with the slider on the right
siz...Exchange 5.5 to 2003 Migration Question #3
We are currently migrating users to Exchange 2003 from 5.5. The 5.5 server
is located here and the new 2003 server is located in a different office.
One user (who we have moved already) is trying to access and user's
calendar, but that user is still on 5.5. They are getting the following
unable to display the folder. The information store could not be opened
Any ideas on how to make the user on 2003 (running Outlook 2003) connect to
the user's calendar on the 5.5 server?
The user has the "Owner" permission on the 5.5 calendar.
...moving exchange 5.5 server to a different domain
I have an exchange 5.5 site with 3 servers in it. They are NT 4.0 and
Exchange 5.5 They are all in domain a. There is a two way trust with domain
a and domain b. I need to move one of the servers from domain a to domain b.
Since I have permissions via the trust to the exchange services site acct. ,
is this as easy as removing the server from domain a and adding it to domain
b, then bringing exchange services back up? Or is there a set procedure that
should be followed?
wrote in news:1A7E7702-914A-...RETAIL MARK UP FORMULA
does excel have retail mark up formula built in?
No. You just use the formula.
Selling = Cost * (1 + Markup%)
Please reply to newsgroup, not e-mail
"jimbo" <firstname.lastname@example.org> wrote in message
> does excel have retail mark up formula built in?
...Excel example-formula C4+C5 adds before data in C5 Can I get it t.
I'm trying to create a formula (for example):
In cell D5 I want it to add C4+C5. I would like it to work only after there
is data in C5, but not before. How can I get it to work only when there is
data in C4 & C5? Right now its showing what I have in C4.
=if(count(c4:c5)<2,"Not enough values!",c4+c5)
New Excel User wrote:
> I'm trying to create a formula (for example):
> In cell D5 I want it to add C4+C5. I would like it to work only after there
> is data in C5, but not before. How can I get it to work only when there is
> data in C4 & C5? R...More Formula Help
I am trying to reconfigure my formula so that if A2 is EXACTLY equal to any
cell in the range B2 to B5, display a 1 in cell C2, else display a 0 in cell
Am I close with these formulas???
...What is the formula payment for $48,800 for 30 years at 8% Interes
Please some give me the formular
=SUM(48,800*8/12) ??? The payment is 358.08 but how can figure it I need
the correct formula to get the monthly payment? I have a computer class
THIS IS URGENT!!!!!!!!!!!!!!!!!!
"Help I need the answer asap!!!" <Help I need the answer
> THIS IS URGENT!!!!!!!!!!!!!!!!!!
You are more likely to get the answer you need quickly if you take the time
to form your question clearly and without typos.
> 8 %
> 30 years
> =SUM(48,800*8/12) ???
> The pa...I need help on this ....
Production data Sheet
Job no time
Price data Sheet
Job no Price
Merge Data (This is what i wanted)
Job no time Price
1001 60 $23.08
1001 50 $19.23
1001 40 $15.38
1002 30 $11.54
1003 50 $19.23
1003 30 $11.54
I have 5k rows of data. How can i merge production data and price data
together based on the job No
Where does 23.08 etc. come from?
(there's no email, no snail mail, but somewhere should b...newbie trouble with formula
Hi all..could you please help me with the following formula?
B2 is 7/31/2008. I'm very new at excel, please forgive my lack of
There's nothing wrong with your formula so you'll need to explain the logic
of what you want to do.
Here's what your formula is saying:
If B2-1 = Sunday, subtract 3 days from B2 otherwise subtract 1 day from B2.
Is that what you want it to do?
Microsoft Excel MVP
"jenn k" <email@example.com> wrote in message
news:BE60D6AD-D058-4631-BC33-3522EF...Breaking Formulas using Pivot Table
I have Tab1 that has data in it in the form of a pivot table. I then
have another sheet, Tab2, that pulls data from Tab1. This all works,
but when I try to copy Tab2 into a new workbook (so that I can e-mail
only that tab) a bunch of my formulas in Tab2 fail. If I refresh the
pivot tables they work again or if I do a Replace "=" with "=" it
seems to trick it into working (but some percent formatting changes to
dollar formatting for some reason).
I just want to know if there is an easy way to make the new workbook
without breaking the formulas in my old one.
Thanks in adv...Showing #N/A in a formula
I�m using VLook Up and I don�t want to show the result when it is equal
to #N/A, or change it by another value.
I can do it replacing formulas by values, but I wouldn�t like to do
Thanks a lot!!!!
Message posted from http://www.ExcelForum.com/
Select all the culprit cells and use conditional formatting: change "cell
value is" to "formula Is" and, assuming E1 is the active cell, enter:
=ISERROR(E1), then click the format button, Font tab, make the font white.
"Nekro >" <<Nekro.firstname.lastname@example.org&g...Cannot access a file -- HELP
I have this problem at work (using Excel 2000 Windows 2000) and at home
(Excel 2003, Windows XP Pro). SOMETIMES...not always, I try to access a file
on a network drive I get the message: "path..filename could not be found.
Check the spelling of the file name and verify that the file location is
correct". Once I get the message on that file, I always get it on the
file....but there might be 27 others in the same folder that I can open. And
I get the message if I try to open the file via explorer or via Excel. If I
copy the file to my C: drive it opens fine. I even tried t...#VALUE! On An Array Formula Referencing a Range Outside The Workbo
This formula works only when i have the other referenced workbook open
simultaneously...when it is not open, i get the #VALUE! error....
Fund\Capital\2005\[GV LP Capital 2005.XLS]SUMMARY'!$G$1:$G$95,$F280,'O:\Gruss
Value Fund\Capital\2005\[GV LP Capital 2005.XLS]SUMMARY'!M:M)}
There are some functions that don't work with closed workbooks. You found one
But you could use a different formula to replace the =sumif() portion:
=sumproduct(--('yourpath\[GV LP Capital 2005.XLS]SU...Help GroupWise Plugin for Outlook
Anyone know if Outlook 2003 can be used as a client for GroupWise? There
used to be a plug in module for older version of outlook.
I know that OL can POP mail from GW, but my company has POP disabled.
Any advice appreciated.
Cut off: yourhead to respond
...Formula for adding time 02-25-10
Hello, I want to put in a start time in B2 and have B3, B4, B5, B6 be
filled in with a formula.
If I put 1:00 pm in B2 - B3 would add to 1:40 and so on.
1 Location start time
2 stop 1
3 stop 2 B2 + 40 minutes
4 stop 3 B3 + 55 minutes
5 stop 4 B4 + 35 minutes
6 stop 5 B4 + 75 minutes
8 How long
9 25 minutes
10 30 minutes
11 45 minutes
12 50 minutes
13 75 minutes
Thank you, Doug
Doug, select a cell to t...Incorrect formula #2
I have the following but have made mistakes in the formula.
What I want to achieve is this.
In Cell where formula is. will be nothing, or 10% or 5%.
If a "N" is in Cell N34 and P53>499, or L53 contains a "D" or "P" then the
result is 10% but if a "Y" in Cell N34 then 5%, if neither a N or Y then
result is nothing. Again if R35 is "NT&qu...New to Exchange Server. Help!
Exchange Server 2003. Dear group: I have installed Exchange Server on my
new Windows 2003 Server. Now what? I have no documentation (none came with
the Small Business Server 2003 Premium CDs that I could find). I need an
administrator's guide with setup instructions. Let me vent somewhat . . .
Why does Microsoft sell these products to small nonprofits like us and expect
us to use them without some documentation? If I have missed something,
please let me know. I will gladly eat crow. God bless and thanks for any
Dr. Doug Pruiett
Good News Jail & Prison Ministry...End Of Month Formula
Good evening all.
I am a little stumped here, cannot seem to resolve this simple requirement.
In cell A1 I have the value from 1 to 12 (representing the month). (This is
Now, in cell B1, I would like to enter a formula, so that the last date of
the month in A1 is shown, eg
1 5 30/05/03 .... or
1 12 31/12/03 ... etc
As usual any assistance would be grayefully received.
Outgoing mail is certified Virus Free.
Checked by AVG ant...Circular reference help
Hello, does anyone know whether it is possible to stop Excel 2007 from
firing up Help whenever it gets a circular reference, please?
I have some spreadsheets which, after updating data-links, form
circular references. This is easily corrected by moving some totals
in line with the updated data. I don't disagree with Excel prompting
me that the circular references exist but I do not want it to fire up
the help system. I know the issue and I am just about to fix it, the
only thing delaying me is the Help window getting in the way.
easiest way is Office button/Excel Optio...FOrmula Help Please, Im so confused
I have a formula that outs out net margin which is
=(Margins!$C$6-MIN-'TMobile 18 Costs'!D5)
I also have another formaula that turns negative into positive If a
positive states "FOC" if negative adds VAT and rounds up to nearest
So if a neative was -89 turns it into +89 *1.175 = 105 then changes it
to 109.99 automatically
With me so far. So what i need is a formula that does all that in one
formula so i dont have to create double columns ot work it out!!!!!!
=Margins!$C$6-MIN-IF('TMobile 18 Cos...Formula
Does anyone know any easy way to calculate the value of an investment where
you put for example, $1000 per week into an account that has 6% interest for
12 months. Also, similar scenario where you put $4000 per month into an
account @ 6% interest. How do you calculate it's value after 12 months.
On Jul 7, 11:49 pm, "JoeBloe" <leavemeal...@hotmail.com> wrote:
> Does anyone know any easy way to calculate the value of an investment where
> you put for example, $1000 per week into an account that has 6% interest for
> 12 months. Also, similar scenario wh...Dlookup Help 02-04-08
I am using the following DLOOKUP string.
I am try to use the Dlookup to use a value that I get in the report
to lookup in a query and return me back some text. The problem that I
am encountering is it is selecting the first record in the query and
not based on the customer number.
How are you using this expression? Is it a report Controlsource? If so, what
section of the report is it in, and what section of the report is