Solving a formula
I have the following formula that I need Excel to solve for different values
of P6 ( I have different values of P6 (P7, P8, P9 (reference cells)). I need
the value of x for the different values of P6. Is this possible? It seems
like it should be but I can't find out how to make Excel do this. Please
70000 = P6*((((x/80)*(1/5280))*(2/3))+(((x/40)*(1/5280))*(1/3)))
If I am not mistaken, x equals:
= 22176000000 / P6
Win XP & Office 2003
"Anth" <Anth@discussions.microsoft.com> wrote in message
news:6196C6C5-FC82-42E2-B6A1-B2...if then else statement
On my report I have a field that I need help with. I have written an =If
statement to try and capture all of the variables, but it is too long, so now
I need to write the same expression in code. Here is what I have in my =If
statement (which resides in the Detail area of the Report):
I would like to know what Microsoft product(s) would be could used for the
following results and what the price
of the recommended product would be:
I work for a small company that would like to keep track of the following:
1. the workload of each employee,
2. how many hours are assigned to each each employee for a project,
3. How many hours each employee have spent on each project,
4. A way to tell if an employee is on track for meeting the project
5. A way to tell an employee how many hours they should be working on each
project they are assigned to.
6. A way to...Changing Function to use a Date Input
can anyone please advise me on how to change the function keys.. sa
F10, F11 & F12 to use to input a date into a cell.
F10 to be 01/01/04
F11 to be 02/01/04
F12 to be 03/01/04
What I require is to go to any cell and press the relevant function ke
to Input the associated date
Any help would be greatly appreciate
PS using Excel 200
Message posted from http://www.ExcelForum.com
First, I'm not sure if you entered Jan 1, 2004, Feb 1, 2004, and Mar 1, 2004 or
Jan 1st-3rd, 2004.
Here are a couple of macros. The first turns this on, the second turns it...How can I email an excel file using my outlook contacts?
"cheflady" <email@example.com> wrote in message
<sigh> Please use the big white space to write your question........
exactly the same way you email ANY file.....
go to file\send\mail recipient( as attachment)
> "cheflady" <firstname.lastname@example.org> wrote in message
> <sigh> Please use the big white space to write you...Usage of CRM 3.0
Is there any obligation by downloading the beta? I mean, I am willing to
download it , but only to play a little bit with it, to understand the
internal (SQL) structures, because I have customers with CRM. But nothing
else (by now).
Any ideas? Thank you for your time (and patience with me)
SQL Server MVP
You can download MSCRM v3.0 for testing purposes. You cannot use this
version for production implementations (key is only valid for 90 days).
In case you do fi...Determine cells that drive conditional formatting?
Cells A1:A4 have conditional formatting set up that states if they are equal
to cell A10 they will be highlighted yellow.
Is there a way to quickly see what cells drive conditional formatting? In
other words, we can use Edit -> Go To Special to see which cells have
conditional formatting applied; however, this doesn't show us that A10 is
involved. Since there isn't a formula directly involved, we can't trace
precedents/dependents. Can we only know that A10 is involved in the
formatting of A1:A4 by selecting those cells and going into the conditional
format...Count "," in a cell
Is it possible to count "," in a cell please?
I used this ... but does not work
Say below ... can it be solved?
Remember to Click Yes, if this post helps!
"Elton Law" wrote:
> Dear expert,
> Is it possible to count "," in a cell please?
> I used this ... but does not work
> =COUNTIF(FO93,",&qu...tender using outside gift card
does anyone know how to 'pass' the transaction total to an outside exe or dll?
we are trying to process the transaction with a gift card (not an internal
gift card, this GC is another company who wants to 'share' the gift card
balance). basically RMS needs to pass the transaction total to the exe (or
dll) which will query the balance of the gift card (over the internet and/or
local DB). the exe/dll will query its database and return a yes or no to RMS
any help would be appreciated.
You use what's called a "Hook" function t...Transferring data between worksheets using Sheet Command?
Hi for an assignment i have to enter grades for 200 students in 4
subjects. there is a front summary sheet that contains all the subjects
and all the students and their overall grade GPA etc.. anyway this
summary sheet has to be populated automatically from the individual
math, english etc.. worksheets. The guide says to do it using the
'sheet command' any help greatly appreciated.
...1 Cell 2 Values?
Is it possible in excel to have it return two values in one cell separated
by a comma and spaces?
For example I want it to count the number of times in a month the value was
positive and the number of times a value was negative and in the cell I want
it to show
A1: +, -
Is this possible?
Thanks to all,
>Is it possible in excel to have it return two values in one cell separated
>by a comma and spaces?
>For example I want it to count the number of times in a month the value was
>positive and the number of times a value was negative a...text to fit in cell
How do I make the text fit in a cell. I want to be able
to print the page with all of the words in the cell even
if it has to make the cell larger, without going over
into the next cell. How do I do this?
goto 'Format - Cells - alignment' and check 'Wrap text'
> How do I make the text fit in a cell. I want to be able
> to print the page with all of the words in the cell even
> if it has to make the cell larger, without going over
> into the next cell. How do I do this?
Format>Cells>Alignm...Totaling cells from separate worksheets to master form
If I have 2 separate worksheets with individual cell values and want the
total to show the sum of obth cells, how do I do it?
Suppose those values are in F10 on one sheet and in G6 of the other
sheet, then put this in the appropriate cell of your master sheet:
=3DSheet1!F10 + Sheet2!G6
to add them both together.
If your actual sheet names contain spaces you will need to include
apostophes around the sheet name, like:
=3D'First Sheet'!F10 + 'Second Sheet'!G6
Hope this helps.
On Apr 21, 10:31=A0pm, snake941 <snake...@discussions.micros...FOrmula to work out pricing rounding up and down
I have a formula in cell that reads "=3DIF(C7>0,"FOC",-C7*1.175)" it
turns a negative into a Positive and a Positive FIgure into answer of
"FOC" Sometimes it will display a result of =A32 or =A35.50 or whatever
the figure when the original answer is a negative.
With me so far!!
The result which is displayed as a number i need it to round up t the
if c7 is =A34.00 display answer of 9.99
if c7 is =A311.00 display answer of 19.99
if c7 is =A328.43 display answer of 29.99
So no matter what the answer is it rounds up to the 9.99 answer...Global variable #3
Visual C++ 6.0
Is it possible to use the declaration "BYTE* buf = new BYTE" in the
..h file for global use by multiple routines?
If so, how do I clear the array to load different data into it?
> Visual C++ 6.0
> Is it possible to use the declaration "BYTE* buf = new BYTE" in the
> .h file for global use by multiple routines?
> If so, how do I clear the array to load different data into it?
How to create a global:
// h file
extern BYTE* g_buf;
// in a function in one cpp file
g_buf = new BYTE;...Dumb question... how to create a Enterprise Formula Custom Field
Guys, I'm writing because I've tried and search but can't get it ...
From PWA I created a Project Custom Field "MyField" of type Text with the
"Hello World", I tried with " and '. When I open a project the field returns
#ERROR. I published to see if magic happens, but nothing.
I did the same with type number and formula 10, same result.
So In the end, I can't get any formula to work. What am I doing wrong ... I
googled with no success.
Perhaps try opening the project and hitting the F9 button to refresh calculations?
Does ...Help me with formula
I have a basic graph 1,2,3,4,5.....going down in and a,b,c,d,e,f,c going
A B C D E F G
1 500 25 75 800 (200)
My question is how can I make an equation that Goes like this :
I showed an example above for on row but i wouuld wnat this to work for
any row no matter what data I answer.
I want this ewuation to work for any data entered for the whole sheet.
I hope you understand and can help anyone.
------...Christmas lights macro #3
Thanks for that.
I'm a complete XL dummy. Can you please explain in 2 sentences how
get that into the spreadsheet and run it
pmolsen's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1511
View this thread: http://www.excelforum.com/showthread.php?threadid=26744
See David McRitchies notes at:
"pmolsen" <email@example.com> wrote in message
news:pmolsen....Format Excel cells
Anyone could help me to solve this problem :
How to format the selected cells so that it allows other users to "paste
values" only(number from 0 to 100) to the cells. It rejects "paste" function
which put formula, format etc into the cells. Thanks a million !
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreade...cells changing from number to date
I am putting a number in a cell, then tabbing to the next cell, the previous
cell changed from a number to a date. How do I keep the number there?
What are you inputting, a fraction?if so, format as # ??/??
(remove nothere from the email address if mailing direct)
"firstname.lastname@example.org" <email@example.com@discussions.microsoft.com> wrote in
> I am putting a number in a cell, then tabbing to the next cell, the
> cell changed from a number to a date. How do I keep the number there?
...formula = ADD whatever is not highlighted.
I have a workbook which I use as my monthly budget. I
have tried other software made for that, but this is
really what I like.
As transactions go through, I "highlight" the cell, using
a variety of colors. I would like 1 cell (presumably,
one that would calculate, what is left to go through) to
add only the cells that are not highlighted, in a certain
Any and all help is greatly appreciated.
These should help.
mysum = 0
For Each c In [m1:m5]
If c.Interior.ColorIndex = 2 Then mysum = mysum + 1
For Eac...How to use this DeleteEMFs() Macro
This macro was on the MicroSoft website as a work around for the .emf
What exactly does this macro do and how should I use it? I want to
remove all the .emf files from a particular Excel File. B/c the
workbook creates hundreds or thousands of temp .emf files everytime it
opens and it takes forever to open..
Thank you very much for any help!
Private Sub Workbook_Open()
Private Sub DeleteEMFs()
Dim fso As Variant
Set fso = CreateObject("Scripting.FileSystemObject"...CALCULATING DEPRECIATION USING ACCESS
HOW DO I DO IT?
Why don't you ask the Access newsgroup instead of the Microsft CRM ng?
Office Equipment & Supplies at http://www.presentationsdirect.com
"PATRICK" <PATRICK@GLWHOLESALE.COM> wrote in message
> HOW DO I DO IT?
I am having a strange issue with my excell file since a while. This is the
second year I am using it without problem. I start a workday with a new sheet
so every morning I just copy (Edit/Move or Copy Sheet) the latest sheet,
rename it and use it.
All of a suddent when I perform this operation I have a prompt that says "a
formula or sheet you want to move or copy contains the name 'aaa', which
exists in the destination worksheet. Do you want to use this version of the
I would hit yes to proceed, then I would get over 50 other prompts with
differ...Using 'Add to Favourites' option on a shared calendar not working
In Outlook 2007 we have a few users who are unable to add a shared calendar
to their Calendars->Other Calendars list. The steps that work on a mojority
of computers are:
1. Go->Folder List.
2. Navigate to Public Folders->All Public Folders->...->Communal Calendar.
3. Right Click on Communal Calendar and select 'Add to Favourites'.
4. Click OK on 'Add to Favourites' dialog.
5. Go->Calendar and the calendar should have appeared under 'Other
However, in a few cases when OK is clicked in step 4 the calendar never