Embedded Bigger Than Smaller Than-IF
Jul 13, 2009
The jist of the problem is that employees are paid their normal wage up untill 37.5 hours of work. From 37.5 to 40 hours of work they are paid 1.5 times their wage. Any hours over 40 are paid at 2 times the regular wage.
So i need a formula that can work out their total pay. Im not sure what i could put in a dummy document to help you since it would just be one cell for their hourly wage, one for their hours worked and then one for the calculation. so you can reference any cell as an example and assume £6 as hourly rate
View 3 Replies
ADVERTISEMENT
Apr 9, 2014
I have a list with random ordered numbers (each number in a cell of a row): 1, 2, 6, 8, 11, 12, 16...
On the other hand I get a value (x). I want a formula that:
- If x is in the list, returns x
- If x is not in the list, returns the next higher value. For example, if x=8, returns 11
I want also a variation of the same formula, that returns the next lower value. For example, if x=8, returns 6.
Note that x will never be smaller than the first number on the list or higher than the highest number in the list.
View 1 Replies
View Related
May 25, 2014
As you can see in the picture, the box which I am writing in won't get bigger. I want it to cover the whole workscreen, but so far nothing has worked.
View 3 Replies
View Related
Nov 7, 2007
how can i make the drop down box bigger to display my text?
heres my problem
http://img220.imageshack.us/my.php?image=probij1.png
View 14 Replies
View Related
Jul 8, 2009
Sometimes my brain just fails me and I'm pretty sure this is a simple one:
In M5:
IF(ISBLANK(L5), (Use whichever number is greater: G5 or H5), (otherwise Subtract L5 from greater of G5 or H5))
View 4 Replies
View Related
Mar 30, 2007
Is there a forumula that will allow me to find the smallest number in A1:A10 that is also larger than the number in B1?
View 14 Replies
View Related
Mar 12, 2009
i found this example of a combobox at http://msdn.microsoft.com/en-us/library/ms996411.aspx. but I don't think it is for excel. Is there anyway I can use code to make it so my combobox's list will be like the picture so it shows all the words instead of cutting them off?'
View 5 Replies
View Related
Apr 10, 2007
I have a file about 13 Megs. I deleted a lot of data and saved it. It was 1 Meg bigger. I closed it, reopened, saved again. 700 k smaller than before, but still bigger than original. That is strange. There must be a way to get the dirt out.
View 9 Replies
View Related
Apr 5, 2009
Is there any way witch i can use to make the auto-filter range bigger than 1000 cells?
View 2 Replies
View Related
Mar 28, 2014
I built what I can only describe as a fantastic spreadsheet. It wasn't until after that I realized it is 123 MB in size, but even for the complexities within it, it still feels like that is quite large.
I can't share the file due to proprietary reasons, but any general tips as to things I can do to make it smaller (and therefore faster to run).
I tried saving it as a binary spreadsheet and that dropped it to about 80 MB, but I don't really know what that does and if it will impact the sheet performance in any way.
View 2 Replies
View Related
Dec 21, 2005
When grading children's test scores I want to apply letters and numerals to particular ranges eg between 21 and 25=3c 26and 30=3b. Please help with a formula.
View 14 Replies
View Related
Apr 22, 2014
I have some spreadsheets containing substantial rows of data, basically 3 columns as this:
Sample
Start
End
Difference (End-Start)
A
1500
1600
100
[Code] ......
And what i want to obtain is different rows of data such as every row has the same difference (20 in this case, without changing the first column), like the following (never mind the colors, they are only to make my point clear):
Sample
Start
End
Difference (End-Start)
A
1500
1520
20
[Code] ........
We can also think about splitting only one certain number into 20's, like in the case of samples B and C above, because I have already split the data into separate sheets based on their "difference" value, using link:
Copy to new worksheets. Do you think it is doable?
View 2 Replies
View Related
May 16, 2007
I have a 30 in monitor (I know I'm lucky!) but when I open a new spreadsheet it opens all the way across the screen 100 columns and 100 rows. How can I change the size when it opens?
View 9 Replies
View Related
Apr 20, 2006
Is there a way of eliminating un-used rows & columns to bring your file size down.
I already know about eliminating unnecessary pages, and I've cleaned up defunct modules, etc., and anything else that's just clutter.
The Row & Column thing would be a big help.
View 7 Replies
View Related
Jun 20, 2008
If any cells in (Specified Range) are greater then (Number) then say true else say false. And how I would write it.
View 2 Replies
View Related
Nov 13, 2009
I have a DDE feed going into an Excel spreadsheet which gives me a share price in real-time. i.e the cell value is constantly changing.
I would like to create a formula that tells me if the price is 'Rising' or 'Falling' based on the previous value, before it was updated.
So, for example, if cell C4 said £1.00 and the the next price change changed cell C4 to £1.05 I would like cell C5 to say 'Rising' If the next price change was say to £1.04 I would like cell C5 to say 'Falling'.
View 12 Replies
View Related
Oct 24, 2013
I have this table with some information that I need to work with. The data is simple, but it has many issues, at least for me, to be able to work with it properly.
Basically, I just need to transfer part of the data from this table to another table (in another order). I failed to use vlookup because I need more than one parameter to search the data (Date, Shift and Sector).
The problem I am having to get the codes from the source table is that the same code sometimes shows up more than once per date, per shift and per sector. It's also not following a numeric pattern. I couldn't elaborate any combination of formulas to get the info I need....
I also can't change the format of the source table, because I'm not the one who made it, it has years already, and is constantly updated day by day by a good old man who doesn't know much about computers.
The file is attached : Example.xlsx‎
View 4 Replies
View Related
Dec 17, 2013
I have an excel spreadsheet that has over 10 thousand rows and is 40+ Mb in size. It is giving me timeout errors when trying to import it into Joomla 2.5. Therefore, I need a way that I can easily split the file into 5 smaller files. Here are the column headers: titlemetadescmetakeyaliascategory_pathstateintrotextaccess
I tried doing it manually but is said the cell sizes were different...
View 3 Replies
View Related
Dec 12, 2012
I need a formula that states: If the number in A1 is larger than the number in C6, but smaller than the number in B6, select the number in D6. But, if the number in A1 is larger than the number in C5, but smaller than the number in B5, select the number in D5 and so on through Row 2.
A
B
C
D
1
#
2
0.4
10.0%
[Code] ....
View 2 Replies
View Related
Feb 23, 2007
I have a table of data, one column is for the names of all these branches of our offices, that consist of 2 alpha numeric digits. For instance one branch is 6G, then another is 6F, 8G, etc. The other column has a raw number in it. So I'm doing a vlookup for the first column to return the value in the second column. But, vlookup automatically returns a value thats the next one over if it can't find the vlookup value. For instance, if it can't find 6G it'll just give me the number it finds for 6F. But I don't need that! I just want it to return either a zero or n/a if it can't find 6G.
View 4 Replies
View Related
Mar 4, 2014
Is there a way to reduce a file's size to make it smaller with faster load times? I have a file that has ballooned in size due to the number of formulas and images I have installed.
Sometimes the file shuts down on it's own and make's my computer really slow.
View 6 Replies
View Related
Jan 4, 2014
I have a table that contains all my data and would like to filter it by company into their own tables that will stay up to date with the main table and then hopefully somehow calculate their investment returns (future stage). I thought Microsoft Query would work but I came across a problem see my other post MS Query returning data to excel some columns I cant sum looks like text
Excel 2010
View 1 Replies
View Related
Nov 27, 2008
I'm using nested IF functions to reduce a large number of bands to a smaller set using the following formula:
=IF(LEFT(D4,1)="
View 9 Replies
View Related
Dec 12, 2009
On this forum, a script is provided to break a large Excel file into smaller 500-line files:
Split Worksheet Into Multiple Files By Every Nth Row
I copied the code and pasted it into the VBA editor in Excel 2007, but when I run the macro, it generates an error message:
Runtime error 91: Object variable or With block variable not set.
The line the debugger identifies as the one with the error is this one:
For lLoop = 1 To rLastCell.Row Step 500
Here is the full code from the previous thread: ...
View 9 Replies
View Related
Jul 25, 2013
I am doing a spread sheet for to enter the times that i do in a rally.
So if i post a time of 00:49.3 and the target time is 03:54.3 i want the cell to turn red, or if the set time is less then the target time it should be green.
How can i do this in excel
View 5 Replies
View Related
Jul 17, 2014
I have a lot of data to try and summarize but they are in multiple smaller tables. I wish to only extract 2 variables, 'number' and 'total' from all of my smaller tables (lots of them) so the problem looks like this, i have these tables for example where the 'total' title is in a different column depending on which of the smaller tables you are looking at:
cat 1
cat 2
cat 3
total
[Code]....
I am trying to get:
number
Total
123456
30
234567
60
[Code]...
Because the number column is fixed and all of the smaller tables will all have a number in the same column maybe i can insert a column next to the number column and say "find the value where the column title is 'total' - however the location of the column title would change so not sure if this would work? I was also thinking of sorting the columns but that will not work either because of the smaller multiple tables?
View 4 Replies
View Related
Feb 11, 2006
I would like to embed a chart that updates from the web into my spreadsheet. This is it here:
[url]
View 9 Replies
View Related
Dec 15, 2009
Working on automating a data update process for my department (well, for the Italian speaking analysts anyway). I'm trying to import data from an embedded PDF to my Excel 2007 worksheet - I only need the data on the PDF, but if the whole screen can be scrapped I can clean it up in my code.
Any ideas if/how I can do this?
View 12 Replies
View Related
Feb 12, 2012
Can embedded macros be found within the new Solver and how would you make the changes you need in VBA with different constraint analysis?
View 3 Replies
View Related
Jan 14, 2014
My "Drawing" is embedded on Sheet1, later on in Sheet12 I click a button that'll send an automatic email to a user. I want to attach the embedded PDF onto this email if it is at all possible??
Code:
Dim Drawing As Object
After I've declared my variables I've tried setting the variable "Drawing" to the object, this is where I'm encountering my errors mainly "Type Mismatch" or Object Variable not set...
Code:
Sheets("Menu").Visible = True
Drawing = Sheet1.Shapes.range(Array("Drawing"))
Selection.Verb Verb:=xlPrimary
Sheets("Menu").Visible = False
At the bottom of the code, this is where i pull in the object
Code:
.To = Sheet12.range("L8")
.CC = ""
.BCC = ""
.Subject = "Arrange P&D Request"
.htmlbody = strbody & vbNewLine & Signature
.Attachments.Add ("Drawing")
View 9 Replies
View Related
