A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
How do I set a maximum value (e.g. cap at 200) by LeeLobb
I have a formula set to multiply a rate by a quantity, I then need to cap the total at 200 example: 42 people x 86 minutes x $0.05 = $180.60 but I need the...
June 24th 16 03:04 PM
by DUV Go to last post
7 36,792
Using the IF and VLOOKUP Function to calculate the tax rates and tax deducted by nerrawsl
I need to calculate the federal tax rate. The federal tax rate is a function of the adjusted income and the employee's marital status. Reference the tax tables...
June 14th 16 03:53 AM
by GS[_6_] Go to last post
3 2,006
Need formula to test if cell is a multiple of 28, but not including 28 by Wazzel
I have successfully used =IF(MOD(G3,28)=0 to identify whether my cell value is a multiple of 28, but I need for it to exclude 28 itself. The very simple...
June 10th 16 09:38 PM
by Wazzel Go to last post
4 1,010
left, search mid by [email protected]
Hello I have a spreadsheet send to me and the only thing I need to do is extract 2 numbers 1. I need to extract numbers between the first( )to one cell then...
June 7th 16 08:02 PM
by Claus Busch Go to last post
3 963
HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN by FRANK
I HAVE A COLUMN OF FIGURES I WISH TO MAKE TWO MORE COLUMNS ONE SHOWING POSITIVE VALUES ONE SHOWING NEGATIVE VALUES
June 5th 16 05:56 AM
by Deb_z Go to last post
6 4,013
Countifs between a certain value by [email protected]
HI I need to count the values between a set value, and then only show how many times this count was more than 5. The values counted is variable only the...
June 3rd 16 09:29 PM
by Claus Busch Go to last post
3 792
Need Formula For Extracting Part Numbers by tb
I am using Excel 2010 for Windows. I have a database of part numbers like this one: 10_32M2A050A002 CYLINDER Please note that there are two blank spaces...
May 31st 16 10:57 PM
by tb Go to last post
3 845
Index / Match with condition by b_nuruddin
Part 1 I have a spreadsheet with two tabs. In the first tab (Sites) I want to populate column B with a "Y" or "N" based on whether or not the site exists in...
May 31st 16 06:22 PM
by b_nuruddin Go to last post
2 972
Using the Time function with an IF statement by Allison Mazurek
HI - I was hoping someone could help me with a time function. =IF(W2=$B$2,IF($Z$2>TIME(11,30,0),'Current Day Balances'!$B$4-'Current Day...
May 31st 16 06:07 PM
by Claus Busch Go to last post
5 830
1 Attachment(s) Formula to get the dynnamic date of the month by shiva_reshs
Hello, I have several reports that I need to send to several people on certain days of the month. So to avoid the last minute preparation, I prepare the...
May 31st 16 05:24 PM
by Claus Busch Go to last post
1 776
Dupes in a range by L. Howard
How can I make this formula respond ONLY to two-digit values in a range? (Array Entered) =IF(MAX(COUNTIF(Data1,Data1))>1,"Y","N") Where the values may also...
May 29th 16 10:58 PM
by GS[_6_] Go to last post
7 876
Join two functions by b_nuruddin
I have two if(and(or statements that work separately but cant figure out how to join them together into one. Is there a way to join or re-write the following...
May 27th 16 07:07 PM
by b_nuruddin Go to last post
2 827
Convert QuickBooks time format to excel to calculate by Misty May
When I export a Quickbooks "Time by Job Summary" report to Excel, the time is converted in a time and date format. If I want to put a dollar amount to that...
3 1,804
How do I calculate variance between numbers? by copitta
I have two columns of scores. I need to calculate the variance (difference) across the two columns, with the result in column three. Seems simple but I...
5 2,183
data arrangement by Nitya Satheesh
Hi ! I have a 2 worksheets with data, worksheet 1 col A Col b colC point location value 1 3 a 1 4 a 2 5 ...
May 19th 16 08:36 AM
by Nitya Satheesh Go to last post
4 1,243
Displaying all combinations of a range of numbers by Mally
How do I display all the combinations of a group of numbers Example Cell A1='3' Cells B1='1', B2=3, B3=9, B4=20, B5=25 This will display all the...
May 10th 16 07:54 AM
by mpokos Go to last post
5 2,332
SUMIFS linked to other workbook, returns #VALUE! by GijsKijlstra
Besides 2016 data in my 2016 workbook, I have there 2015 data for comparison purposes, with SUMIFS formulas linked to my 2015 workbook. The 2016 workbook...
May 9th 16 03:42 AM
by GijsKijlstra Go to last post
2 1,251
Min function pull down formula by L. Howard
With columns A & B, in column C a formula to pull down that will return an "m" for the minimum value of the A column "groups". So for the three 123's the min...
May 5th 16 05:58 PM
by L. Howard Go to last post
4 1,223
time decision for open file in Excel by [email protected]
20 hours before current time is today,open file A 20 hours before current time is yesterday open file B. How can I use IF THEN function in EXCEL macro
3 2,076
Can't insert a new worksheet by [email protected]
On Sunday, August 1, 2010 at 2:19:26 AM UTC+5:30, Jack Deuce wrote: > I have 4 spreadsheets, one for each school, each containing 100+ > worksheets with the...
0 1,066
Post New Thread


Display Options
Showing threads 81 to 100 of 88516
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 On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:54 AM.


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