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 » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 0.73 seconds.
Search: Posts made by: FloMM2
Forum: New Users June 4th, 2010, 05:03 PM Posted to microsoft.public.excel.newusers
Replies: 5
Views: 2,095
Posted By FloMM2
What Excel formula converts hourly wage to annual salary

Entre Nous,
You will have to make a few assumptions:
1. full-time is equal to 40 hours per week
2. there are 52 weeks in a year

Once you have done that, it is simply hourly rate times 40 hours...
Forum: Links and Linking June 4th, 2010, 04:56 PM Posted to microsoft.public.excel.links
Replies: 4
Views: 7,542
Posted By FloMM2
Remove Hyperlinks

Jester,
Have you tried to select the cell, select "Insert", select "Hyperlink" and
"Remove Link" ? Even if you use the hyperlink, the cell will remain selected
after the web page opens. Just close...
Forum: General Discussion June 4th, 2010, 04:43 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 461
Posted By FloMM2
Vlookup and Hlookup help

Nikki,
Another solution:
In the cell for the total of "Product A" from "Company A" type this:
"=IF(B1="Company A",SUMIF(A2:A25,"Product A",C2:C25),0)" without the
beginning " and ending ".

This is...
Forum: General Discussion May 20th, 2010, 03:57 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 174
Posted By FloMM2
Formula to reference another cell in a worksheet

HeatherJ,
If you want the cell in F column to equal the value in cell in the A column:
"=$A1" without the quotes (" ").
If you want the cell in the F column to equal the value in the cell A1:
...
Forum: Charts and Charting May 20th, 2010, 03:47 PM Posted to microsoft.public.excel.charting
Replies: 1
Views: 356
Posted By FloMM2
Template for Hours+ Commission

jcompugraph,
Could you give more information?

"jcompugraph" wrote:

looking for Template for Hours+ Commission in excel 2003
Forum: Charts and Charting March 13th, 2010, 05:49 AM Posted to microsoft.public.excel.charting
Replies: 2
Views: 168
Posted By FloMM2
Chart moves on plot area when adding a third month

Melody,
I have to do a similar thing every month, so I know how you feel.
This is what I came up with:
Is the chart on a separate sheet? If so, select the chart "sheet" and then
left click on the...
Forum: Charts and Charting March 3rd, 2010, 08:29 AM Posted to microsoft.public.excel.charting
Replies: 3
Views: 143
Posted By FloMM2
Formulae Help

JEM,
The logical test is "If(' Data'!$O$32=0" without the " ",value_if_true is"
"" " without the first and last quotes, value_if_true is, " ' Data'!$O$32"
without the first and last quotes.
In...
Forum: Charts and Charting March 3rd, 2010, 08:16 AM Posted to microsoft.public.excel.charting,microsoft.public.excel
Replies: 2
Views: 167
Posted By FloMM2
Pivot Chart - negative values not displaying properly

Aleksandr,
This may be silly to ask, but...
Did you try and adjust the y-axis scale from 0 to some number to a negative
value (greater than the lowest negative value) to some positive value.

Ex....
Forum: New Users February 15th, 2010, 07:48 PM Posted to microsoft.public.excel.newusers
Replies: 1
Views: 133
Posted By FloMM2
How to re-size a Balance Sheet template??

Issac F,
Did you try this:
Once you have the workbook set with all the information that you want.
Select "View", "Page Break Preview".
You will get a warning on making changes, select "OK".
Move the...
Forum: General Discussion February 1st, 2010, 08:05 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 128
Posted By FloMM2
Drop Box Width

JDH,
If I understand you correctly, the drop down boxes is wider than the column
you are selecting iteems from a validation list.

That being said, try this:
Select a cell in the column with the...
Forum: Charts and Charting January 20th, 2010, 07:57 AM Posted to microsoft.public.excel.charting
Replies: 1
Views: 129
Posted By FloMM2
How to display both $ in pie chart and % in legend

Christi,
This is what I came up with:
Cell A2 "Total-C" Cell B2 "$90" Cell C2 "59%"
Cell A3 "Total-K" Cell B3 "$24" Cell C3 "15%"
Cell A4 "Total-L" Cell B4 "$40" Cell C4 "26%"

On the Series tab,...
Forum: New Users January 16th, 2010, 02:47 AM Posted to microsoft.public.excel.newusers
Replies: 1
Views: 116
Posted By FloMM2
i am trying to fill a column with dates in descending order

zanc1one,
First format the column the way that you want it (i.e. Date ,Type:
"14-Mar-01")
In the first cell say A2 put "31-Dec-10".
In the cell below it (A3) put "=A2 - 1"
It will change to...
Forum: New Users December 30th, 2009, 08:06 AM Posted to microsoft.public.excel.newusers
Replies: 3
Views: 114
Posted By FloMM2
Page Preview/Print Problem

,
Try this and see if it helps:
Along the top menu select "View", then "Page Break Preview"

This will show where you set, or someone set the page breaks on this
worksheet.
Move...
Forum: General Discussion December 28th, 2009, 06:53 AM Posted to microsoft.public.excel.misc
Replies: 2
Views: 75
Posted By FloMM2
excel

Mark,
You google "excel templates" or try this link:
http://office.microsoft.com/en-us/templates/results.aspx?qu=invoices&av=TPL000
There is a list of files (free) to download, you can then...
Forum: General Discussion December 26th, 2009, 09:18 AM Posted to microsoft.public.excel.misc
Replies: 5
Views: 116
Posted By FloMM2
Macro is not working properly

Sherees,
Since you didn't post the macro for inspection and help. I will take a shot
in the dark for you.
Look at the coding of your macro, if it refers to the workbook by name, then
eventhough...
Forum: Charts and Charting December 13th, 2009, 08:25 AM Posted to microsoft.public.excel.charting
Replies: 1
Views: 155
Posted By FloMM2
Copy paste error

ganeson r,
Have you tried first inserting a table in your word document then pasting
the excel file into the table?
hth
"ganeson r" wrote:

paste option is disable when ever I paste excel...
Forum: Worksheet Functions December 11th, 2009, 08:27 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 64
Posted By FloMM2
Monthly files

dimitry schaff,
One way you could do this, is to set it up once and save it as a template
file.
The next time you open the file, to input data. When you are done, save the
file as that...
Forum: Worksheet Functions December 11th, 2009, 08:21 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 70
Posted By FloMM2
Pop-up box

Phil,
This is what I came up with as a solution:
Make the sheets in the file as "Monday, Tuesday, Wednesday, Thursday,
Friday, Saturday, Sunday" and save it as a Template.
On sheet "Tuesday" in...
Forum: New Users December 10th, 2009, 06:24 AM Posted to microsoft.public.excel.newusers
Replies: 1
Views: 161
Posted By FloMM2
Need help in making my invoices auto count

Lostinexcel,
Have you checked out MicroSoft's free templates?
at: http://office.microsoft.com/en-us/templates/default.aspx
You can search for "Invoices" there. Depending on whether you are using...
Forum: Charts and Charting December 1st, 2009, 08:38 PM Posted to microsoft.public.excel.charting
Replies: 3
Views: 96
Posted By FloMM2
printing problems

Kim2900,
Have you varified your page breaks?
Select "View", "Page Break Preview".
Click the "OK" button.
Then drag and drop, page break lines where you need them.
hth

"Kim2900" wrote:

I am...
Forum: New Users November 28th, 2009, 04:35 PM Posted to microsoft.public.excel.newusers
Replies: 3
Views: 109
Posted By FloMM2
how do I display negative numbers a "0"?

Ken,
If your formula is as follows:
"=A1-B1"

You would need to edit as follows:
"=IF((A1-B1)0,(A1-B1),0)"

What this tells excel is, if A1-B1 is greater than 0 (True), then give me
that result....
Forum: New Users November 17th, 2009, 03:42 PM Posted to microsoft.public.excel.newusers
Replies: 9
Views: 315
Posted By FloMM2
formatting of row depending on cell value

Redbeard,
This is what I came up with:
If you can add a helper column.
Then in the first cell in the row -
Add conditional formatting
Condition 1
"Formula Is" "=$A$3=$B$3"
Select...
Forum: General Discussion November 17th, 2009, 02:59 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 135
Posted By FloMM2
Losing Print format when copying wrksht to wrksht or wkbook to wkb

MK,
Have you tried this:
1) Setting up a template
or
2) Saving the first file "generic quotes" as a Save As "John Smith's quote
file"
hth

"MK" wrote:
Forum: Setting up and Configuration November 15th, 2009, 03:00 PM Posted to microsoft.public.excel.setup
Replies: 2
Views: 335
Posted By FloMM2
Using worksheets at a form but formulas are not working

evilthorne,
Once you have your worksheet setup the way you want it. Columns width, row
height, drop down lists, and formulae are all set. Save the workbook as a
template.

Select "File", select...
Forum: General Discussion November 13th, 2009, 05:06 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 138
Posted By FloMM2
if then and conditional formatting of dates

KidA,
This is what my solution looks like:
Column E Column F
9/11/2009 10/11/2009 (in Red)
10/13/2009 11/12/2009 (in Red)
11/12/2009 12/12/2009
11/13/2009 ...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 09:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.