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 Replies Reverse Sort Order Views
using a checkbox for a conditional function by Brac
Not sure if this is the best way, but what I want to do is have a pricing form for quotations and output the pricing information to the appropriate cells with...
December 8th, 2005 07:12 PM
by Wolmot Go to last post
4 117
Changing the colour of a logic expression by cjrrussell
Hey guys I have this logic expression in a spreadsheet =IF(C19C18,"YES","NO") What i want to do is if it returns a value of NO make the text red. Is this...
December 8th, 2005 05:36 PM
by Bob Phillips Go to last post
4 166
Excel If Statements, please help! by izzie
I've been trying to make multiple IF statements but it says that I have too many arguements. The problem is, I need to have a calculation for my work. Here's...
December 8th, 2005 09:36 PM
by JR Go to last post
4 167
Conditional Formatting by Ant
I have a workbook where I would like to apply conditional formatting to an entire row, depending on the condition in the first column. I know how to apply the...
December 8th, 2005 09:44 PM
by Gord Dibben Go to last post
4 270
Splitting the contents of a cell? by Dan B
Hi, I have several columns of data that contain data such as:3001001E:Name I want to keep what is on the right side of the colon. How could I do this with...
December 8th, 2005 09:34 PM
by Dan B Go to last post
4 134
Conditional Formating by Trying To Excel
=A1=MIN($A$1:$C$1) click format and select red font, click OK twice Can I copy or expand this to include al the cells down to A25,B25,C25
December 9th, 2005 09:04 AM
by Trying To Excel Go to last post
4 215
Date formula needed by Rich Hayes
Hi If in cell A1 I have a month name for example: 'January' In cell D1 i want to say, if the month in cell A1 says 'January' then add a month and show...
December 9th, 2005 08:25 PM
by Ron Rosenfeld Go to last post
4 103
Formulas in Excel XP by Rebecca
Trying to insert a 5% price increase into a range of cells. I.e. - customer price list will recieve a 5% increase... Is there any way to to insert a formula...
December 9th, 2005 05:52 PM
by Rebecca Go to last post
4 139
Macro for cell selection starting with Last Cell by Valerie
I want to go to the last cell on the worksheet and select it along with 16 prior cells in order to delete the last 16 rows of the worksheet at once instead of...
December 9th, 2005 09:25 PM
by Valerie Go to last post
4 119
US dates to UK?? by Bill
I have an Excel 2003 spreadsheet that has a column full of dates. I have no control over how the spreadsheet has been configured. The dates are in an American...
December 8th, 2005 07:44 PM
by vezerid Go to last post
4 269
formula I can't figure it out?! ARGH by jewels
I am trying to make the following formula work and am going nuts trying to make it work - I even called Microsoft and they couldn't do it either? Here is what...
December 8th, 2005 02:04 PM
by jewels Go to last post
4 131
Function for generating monthly & weekly averages by picklet222
I have a running list of dates in column A, but there are some missing dates. There is associated data in column B. I'd like to put weekly averages (Week is...
December 8th, 2005 10:00 PM
by picklet222 Go to last post
4 213
Maybe I need help with Lookups?? by garry05
Hi all...a newbie here. I'm okay with many Excel functions, but I don't go too deep: Can't do macros, lookups, that sort of thing. Here's my dilemma: ...
December 8th, 2005 03:26 AM
by Max Go to last post
4 161
Countif, then multiply?? by Gee-off
A B C 1 S6 B2 I know how to use the countif function as if to count all values that equal "S*" (value beginning with "S" only regardless of the...
December 7th, 2005 09:55 PM
by Bob Phillips Go to last post
4 130
How do I go from one page to another in excel without scrolling? by GeorgiaB
I want to go to page 15 in a workbook but I am on page 75. How do I get to page 15 without scrolling? Is there a shortcut?
December 9th, 2005 08:34 PM
by Ian Go to last post
4 89
Help with if statement..... by WalterT.
I am trying to create a time sheet for the 15th of the month through the end. I have an empty column for the 31st (S). I want this header (S13) to be blank if...
December 7th, 2005 11:31 PM
by WalterT. Go to last post
4 108
keystroke to close active workbook window by Vickie
Is there a keystroke to close an active workbood window with Excel 2003? I am trying to use the mouse as little as possible. I do not wish to close...
December 8th, 2005 12:21 AM
by Gord Dibben Go to last post
4 90
Overtime computation and lunch break formula with IF and AND by navychef
Hi - I'm having a heckuva time trying to create a formula that will enable me to create an employee work schedule that will alert the manager to scheduled...
December 8th, 2005 08:06 AM
by Bob Phillips Go to last post
4 147
Show blank cell when not Closed or Open by roy.okinawa
I have this formulas in column B: =IF(AH80,"Closed","Open") When I copy this formula down column B into blank rows, Open appears in all those cells below B8...
December 8th, 2005 02:18 AM
by roy.okinawa Go to last post
4 120
Looking for best fit by Greg
I'm looking for a formula to find the 'best fit' for inventory turns. For example: A B C D 1 10 100 50 5 The formula in D1 is: ...
December 9th, 2005 10:27 PM
by Niek Otten Go to last post
4 98
Post New Thread


Display Options
Showing threads 20001 to 20020 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 10:06 AM.


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