Using Inputbox Results To Set Lower Limit On Row
Feb 6, 2014
I am using two inputboxes -
First one asks the user what month their querry starts in - ie january 2011
The second one asks the user how many months their querry is for - ie 12
I would like to know how to use the second input box to set the limit of data for the first box
The first box puts a date in "L2" - ie L2 = January-2011
I would like for the second input box to autofill the dates down col L based on the number selected in the second inputbox. i.e. january-2011, February-2011 and so on.
View 4 Replies
ADVERTISEMENT
Jul 24, 2014
I run an excel spreadsheet to calculate quotations.
Included in this is a cost for the 3 year annual service which is based on 10% of the purchase price, or a minimum of £1000.00
While it is simple enough for this to auto-calculate the 10% I use - =SUM(G3*0.1)
I was wondering if it was possible to set a lower limit so if 10% is below £1000.00 it automatically defaults to £1000.00
View 4 Replies
View Related
Sep 27, 2006
I want to make a line chart that plots a variable over time (say, monthly) and that shows upper and lower limits as the 2nd and 3rd plot. My table layout, boiled down to the bare essentials:
Col 1 = Measurement date
Col 2 = Measurement (pressure, for example)
Col 3 = High limit (never varies)
Col 4 = Low limit (never varies)
The chart/graph in this case would show at a glance how water pressure varies over time and when it goes over (under) a limit. The table has about 50 variables.
View 3 Replies
View Related
Sep 30, 2013
create a formula copying a formula from cell a5 to a20 but i want the result to be 1 cell lower from a5's result
View 6 Replies
View Related
Jun 30, 2009
I have the inputbox so i can set a string value,
When the inputbox Cancle button is pressed i want to exit sub,
If the inputbox value is nothink and ok button, I want the msgbox displayed then goto newname.
If the inputbox has a value do >>>>>>That>>>>>
View 6 Replies
View Related
Oct 27, 2009
I M trying to get the lower values between to cells and have the lower valued cell highlighted,,,i have over 43 thousand lines of data to go throughand i was wondering if there was a quicker way to do this,,,for example cellA1 is $4.25 and cellA2 is $5.25 i want cell A1 to be highlighted,,is there a way?
View 2 Replies
View Related
Oct 8, 2008
Is there a data validation that will not allow all upper case or all lower case characters?
For examples:
Allow:
John Doe
101A N Woodbine Street
Disallow:
JOHN DOE
101A N WOODBINE STREET
Disallow:
john doe
101a n woodbine street
Or perhaps formatting that would convert the words to upper/lower case?
Or, I would be interested in VBA if it is the only way.
View 9 Replies
View Related
Nov 26, 2012
I have 83,33 value. If I like to increase into 84 and not 83 without decimal point
View 11 Replies
View Related
May 11, 2012
I am trying to get a simple formula to look in A1 and if it is lower than A2 then return the value in A1 if it is not then return the value in A2..
View 4 Replies
View Related
Sep 22, 2008
I have this code (this is just a snippet)
For Each cel In Range("E6:AI15").Cells
If IsError(cel.Value) Then
Else
Select Case UCase(cel.Value)
Case "H"
cel.Font.ColorIndex = 0
cel.Interior.ColorIndex = 3
Case "S"
cel.Font.ColorIndex = 0
cel.Interior.ColorIndex = 10
but I want the cells to accept both upper and lower case values and format the cells accordingly ie. H or h, S or s
View 9 Replies
View Related
Oct 6, 2009
I have looked in conditional formatting, but do not see a way to change lower case to all caps. Is there a way to do this so that when someone types in a cell it returns all caps instead of leaving it in lower case?
View 9 Replies
View Related
Jul 27, 2006
I am trying to create formula that will show overtime worked in a given day. The code I am using is a simple one ([ cell - 8], for hours worked). The problem is when the time cells are blank/not used it shows a -8 in the cell. what I need to do to create a code that will eliminate the -8 from showing. The cell its self is taking the result from another cell with a formula and then subtracting 8 from the result of the formula in the other cell.
View 2 Replies
View Related
Apr 19, 2009
The values in F4:F14 are changed depending on the value in F2. The rows in green have a fixed value. The row in yellow has a lower limit (170)and upper limit (195). I cannot get a formula in F14 to perform this function.
View 3 Replies
View Related
Jul 21, 2014
I need to change the all Upper Case character to Lower case character for all cells. See below my code, i am getting error message, Tye Mismatch. "cell.Value = LCase(cell.Value)"
[Code] .....
View 3 Replies
View Related
Mar 5, 2008
i wanted to know if there is a way which i can so that would tell excel if a certain cell value is lower then another it would give a msg
for example
Cell A1 - 5
so if cell A2 is less then five and a macro is clicked then the macro would give a warning msg hence ending the macro
View 11 Replies
View Related
Apr 28, 2009
How to change the lowercase letters to uppercase letters?
While using the userform, for example "name" is entered in the form.
My requirement is the values should reflect as uppercase letters like "NAME"
View 2 Replies
View Related
Jan 22, 2010
I am trying to change string values of a name from uppercase to lowercase. The data is layed out as lastname then first name. As an example, I have the following values in column C:
ANDERSON MICHAEL
SMITH SUSAN P
JOHNSON PATRICK
JORDAN MICHAEL R
WOODS TIGER
CLINTON WILLIAM J
I am trying to convert to following (with "," between lastname & firstname):
Anderson, Michael
Smith, Susan P
Johnson, Patrick
Jordan, Michael R
Woods, Tiger
Clinton, William J
I have a start of how I think the code should flow but can't figure out how to do the conversion.
View 4 Replies
View Related
Sep 6, 2005
=upper("venkat") returns VENKAT
=upper(a1) returns the text in A1 in upper case
similary lower
proper will turn the first letter into uppercase
is this what you want;.
Terry <terrybetts11138@hotmail.com> wrote in message
news:dbl0dk$poa$1@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com...
> Win XP Pro
> Office 2003
>
> Using "Excel" and wish to select any text in a worksheet to ALTER the case
> to either upper or lower.
> When using "Word" it is easy via the menu.
> Is there a menu driven option in Excel
of using a function for this purpose.
View 14 Replies
View Related
Sep 7, 2005
find the "add in" that converts the case text
from lower to upper in excel. i've already downloaded this before but can't
remember where from and it is much easier than creating a formula or a macro
View 9 Replies
View Related
Aug 12, 2006
I have name and a number in this
format: cell a1 Jones---56. In cell b1 I have another name i.e.,
Johnson---45. How can I subtract 45 from 56, take 60% of the difference
and in cell c3 show the following; Johnson---6. All numbers are to
rounded down to 0. The final result would look like this;
a1 Jones----56, b1 Johnson----45, c1 Johnson----6. I have other cells
with the same type of info in them. Example; a2 Smith----34, b2
Jones----78, c3 would show Smith----26.(rounded down) I always want to
subtract the lower number from the highest and take 60% of the
difference.
View 11 Replies
View Related
Apr 13, 2009
I am attempting to change a range of cells from lower case text to all upper case text.
View 4 Replies
View Related
Oct 7, 2013
I want to have some cells with conditional formatting.
The case here is date.
I have a given range of cells which will take on date. I will select all of these and will creat conditional formatting so that if the date is less than 2 days or more, have font colour change to red.
Now, the current date will be refered on a single cell.
I have done =($C$3-2) and it works but this does not account for anything older than 2 days.
What am I missing here? How do I do or less then?
View 3 Replies
View Related
Oct 14, 2009
I have data in cell A1 as below:
36, TREE ROAD, 5TH FLOOR
I want it in proper format in cell A2 as below:
36, Tree Road, 5th Floor
I used formula =Proper(A1), it gave results as:
36, Tree Road, 5Th Floor
The only problem I face is after any number, the next character should in lowercase, i.e. 5th
View 9 Replies
View Related
Apr 28, 2006
Excel is very slow for me, and I have just noticed that there is a 'Calculate' message in the lower bar of the window.
View 9 Replies
View Related
Aug 14, 2006
I have a file with about 30-40 macros in it. In a file with nothing in it, whenever I type the word " range" xl automatically changes it to title case. But I noticed recently everywhere the term 'range' occurs in my macros it is lower case.
View 3 Replies
View Related
Sep 21, 2006
I will enter a figure into A1. I will also enter a figure into C1. In E1 I would like to enter the lower of: 0.2% of A1 or 75% of C1
View 5 Replies
View Related
Aug 13, 2014
I have a number(Currency) in my Cell A1 = $100.00
I have a currency that will be inserted by my user in A2
In A3 I need to have the following:
If the user add a value lower than A1 then Error message "Invalid" but if it's equal or higher then leave as is (Meaning add the value from A2 in A3).
The user cannot add letters if so then "Invalid".
View 6 Replies
View Related
Apr 30, 2014
I have a huge list of data with numbers in cells. each number also has a corresponding percentage in the next cell over. In some cases, some of the numbers appear twice with differentiating percentages in the cells. What I am trying to do is automatically highlight and delete the duplicate number with the lower of the two percentages. See the below example.
2069091%
2069088%
As per above, I would want to delete the duplicate number with the 88% since it is the lower of the two percentages of that number. I have almost 2000 cells and have been going through manually deleting the lower of the two percentages for the duplicate numbers.
View 6 Replies
View Related
Aug 24, 2009
I have a spreadsheet that I am using to track competitor retail pricing
The problem is that I have a list of values and I want to be able to show how many of these values are either higher, lower or the same to a specific cell value. However one complexity that I have is that some of the competitors do not have values for all records (i.e. some are blank) and I want to discount these from the counting.
View 12 Replies
View Related
Dec 19, 2009
I am looking for a formula to return the expected row/location in range B2:B13 as shown in col. F
Col. B dates are and cannot be sorted
The idea is to find the exact or the closest lower date to those in col. E
as per two criterias (col. D+E)
I prefer no helper column and no macro
(see attached WB)
View 14 Replies
View Related