Calculator Compute Automatically After Inputting The Date
Apr 29, 2009
i m making a very small calculator. It's a little hard to describe, but I need to look like the following
Let's say the individual got here on 1 Jan
Phase 1 is for days 1-14 last for 14 days
Phase 2 is for Day 15-35 last for 21 days
Phase 3 is day 36+
This is what I need it to look like: All the phase information will compute automatically after inputting the date arrived. In addition I would also like to be able to change one of the phase dates and the remainder of the phases compensate according to the newly entered date.
Date Arrived = 01 Jan 09
Phase 1 = 01jan09
Phase 2 = 04Feb09
Phase 3 = 05 Feb09
View 10 Replies
ADVERTISEMENT
Jan 29, 2007
i have 1 - 9 number buttons, the +, - , * , / , and a C for clear, as well as an exit button. the display is a label. i have to click add after inputting the digits just to have it added to he variable, which i just add up at the end... terrible.
Option Compare Database
Option Explicit
Dim var1 As String
Dim var2 As String
Dim first As String
Dim second As String
Dim sign As String
' on load
Private Sub form_load()
Form.Caption = "this calculator lab sucks."
Me.lbDisplay.Caption = ""
End Sub
' on clear
Private Sub cmdClear_Click()
Me.lbDisplay.Caption = ""
var1 = ""
var2 = ""
End Sub.............
View 3 Replies
View Related
Nov 15, 2008
First and foremost I would like to congragulate you on this wondeful piece of code in the below link...
The query was to get a future date excluding Fridays and Holidays...
http://www.excelforum.com/excel-work...rkingdays.html
I have a similar query and therefore I pasted this link...
I actually wanted to get a future date using a Dynamic two day off as my the offs keep on changing as well as incorporate Holidays and Leaves if any..
Now Holidays would be official Public Holidays and
Leaves would be taken by the employee..
The code needs to pick the Leaves + Holidays and different offs maybe even more than 2 offs...
View 7 Replies
View Related
Jan 9, 2013
I want to create a macro or formula for changing the colour of the cell after half an hour of inputting.
View 3 Replies
View Related
May 14, 2009
I'd like to know how I go about to key a formula to compute the due date 30days after the invoice date and How to key a formula to determine hours worked.
View 14 Replies
View Related
Feb 20, 2007
for example.
I type "20 Feb 07", and excel formatting auto changes that to "Tuesday 20 Feb 07"
I actualy need this for a more complex formula...
if A1= any date from monday to sunday of one week, then A2= mondays date+21
the only way i can comprehend this is to make a formula that says if A1= a monday A2=date+21, A1= a tuesday A2=date+20, etc.
View 13 Replies
View Related
Aug 7, 2013
I have a problem where there are 4 arguments passed to my COUNTIFS function to give me a total count i.e. "KP","James Report","Completed","Month"
Here is the Formula I used;
=COUNTIFS(Master!$B$2:$B$29,Picklist!$C$8,Master!$D$2:$D$29,B3,Master!$H$2:$H$29,Picklist!$C$2,Master!K2:K57,Picklist!E9 )
The last part of my formula is throwing an error "K2:K57"
What I should get in plain English.... "The number of 'James Report' 'Completed by 'KP' in 'August'. (Any specified month based on what comes from my "dates field" on my Master sheet.
I have got a field in my Master sheet with dates which I have transposed into the right month of the year using Month().
View 2 Replies
View Related
Dec 5, 2008
I have a worksheet with 500 rows. Coulmn A is all the dates of the items. Is it possible to somehow havea userform or something that I input a start date and a finish date and it only shows me that info.?
View 2 Replies
View Related
May 27, 2014
1. Calculate the time that has elapsed between 2 times in both hours:min (hhmm) and total mins (mm)
2. Compute the day of the week (mon-fri) a particular date fell on. I really only need to know if the date fell on a weekday or weekend.
table { }td { padding: 0px; color: windowtext; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Arial; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-size: 12pt; } 1= M-F
2=S-S
3. How to write an If statement that assign a value to time based off this chart:
table { }td { padding: 0px; color: windowtext; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Arial; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-size: 12pt; } 1= AM (7-1459)
2=PM (15-2259)
3= MN (23-659)
View 9 Replies
View Related
Jan 12, 2014
I am trying to create a calculator which will show start date and end date based on the specific date provided.
EX: column A has January 1, 2013, column B has Wednesday, Column C should have a start date which supposed to be 4 days ago (December 28).
View 6 Replies
View Related
Oct 22, 2009
I'm building a calculator of sorts for dates. I have a start date in A1. Next to the start date I have a list:
10 days from -start date- is:
15 days from -start date- is:
20 days from -start date- is:
and so on...
I need a formula to return a date that is however many days specified from the start date. If that date lands on a sat or sun I need it to return me the date for the monday after. For example, if my start date is 10/15/09 (thursday) and 10 days from that is 10/25/09 (sunday) I need it to return the date of 10/26/09 (monday). I also need it exclude a range of holidays i have listed.
View 9 Replies
View Related
Jul 17, 2009
As part of a project, I need to come up with a meter reading calculator. I start of with 3 base meter readings (A2, F2, K2), which would be read from the meter. 3 reads are needed in case the consumption changes dramatically at some point. I then need Excel to work out the reading for dates in between. The formula needs to be dynamic enough so that I can change any of the grey dates to what I want.
The estimates need to be calculated using an average daily consumption. This figure needs to be displayed in D9.
It would be preferable if macros weren't used. If its possible to explain what to do without an attachment, that would be good too.
View 6 Replies
View Related
Aug 4, 2014
cell a1 has yes cell b1 has yes and i want to type yes in c1 that will change a1 and b1 automatically to a blank cell
View 3 Replies
View Related
Jan 20, 2009
i was assigned to make a computation for our individual scores using this:
EMPLOYEES A-N
inputs:
SURVEY(0-100)
LH(lost hour)
AHT(average handling time)
compute for:
SCORE
RANK
the SCORE has a total of 100%
so to get the SCORE, each input gets a percentage: SURVEY=40% LH=30% AHT=30% then added.
but the thing is LH and AHT has an equivalent.
LH
0 to 1=100
1.1 to 2=90
2.1 to 3=80
3.1 to 4=70
4.1 to 5=60
5.1 above=20......
eXAMPLE:
EMPLOYEE A
SURVEY(0-100) = 33.00
LH(lost hour) = 12.00
AHT(average handling time) = 14.20
SCORE = CODE
RANK = CODE
now for the rank i just use the code =RANK(SCORE A, SCORE A:SCORE N)
im lost on how to compute the SCORE though coz i can just use =((SURVEY*40%)+(LH*30%)+(AHT*30%))
but the one that needs to be on the LH and AHT are the equivalents and not the inputs.
and there is 1st 2nd and 3rd place. the name of the top 3 employees should be shown under the table.
View 10 Replies
View Related
Jun 9, 2014
I need to write a formula that will look at a number in a cell and compute an amount at 1% up to 55,000. Then anything above the 55,000 compute an amount at 3.25%. Then add the two together.
So a baseline of 55,000 at 1%. Then above the baseline 3.25%.
View 3 Replies
View Related
Nov 29, 2007
I've attached a Screen Shot of the of 2 Workbook, named Installation Tailgate 2007v1.xlsm and new workbook and i've also attached the excel program itseff in zip.
Installation Tailgate 2007v1 workbook, have a 13 column and nth number of rows ( and will keep growing)
columns D & E are hidden
columns G, I, K, M are checkboxes
if the user clicks on the command button it will copy and paste the selected cells on new workbook
unchecked cells on Installation Tailgate 2007v1 workbook should have a "0.00" on Child workbook.
then compute the Sum of Columns C, D, E, F, G, the total should be on last of their row
View 14 Replies
View Related
Sep 26, 2009
I have 15*2,14*2,14.5 in cell A1 and would like this to be computed and its result (i.e 72.5) displayed in cell A2. See below for clearer picture:
A1 A2
15*2,14*2,14.5 72.5
View 8 Replies
View Related
Oct 5, 2011
I have the following macro to compute data using SUMMIFS
Range("E" & finalrow + 9).Formula = "=SUM(SUMIFS(E8:E" & finalrow & ",F8:F" & finalrow & ",{""PSP101"",""PSP611"",""PSP140",""7*""}))"
The last line up code is mot working as I am tying to using a Wildcard for the last criteria
""7*""
Where text starting with a 7 appears in column F for eg 76601G, 75106K etc appears it must be included in the criteria
Full Code-below
Sub Totals()
finalrow = Range("A65536").End(xlUp).Row
Range("A" & finalrow + 3).Value = "Total Movement"
Range("E" & finalrow + 3).Formula = "=sum(E8:E" & finalrow & ")"
[Code]....
View 1 Replies
View Related
Jul 16, 2013
I've been having a hard time with this i need a formula which will compute a value based on a multiple cell.
I have a cell (AQ) it contains the number of days a patient is in a center i need to countif the cell value is >=90 if it is it will then calculate the values in cell (AV) which is >- 1.4 and get the average of cells in AV.
View 3 Replies
View Related
Aug 4, 2008
I have a question to ask, and not sure what you would call it. I am looking to input a 'Check Box' into a cell so you could have for example... two (2) choices - Yes - No - you would have an empty circle in front of each, and you select the one (1) you wish which would make it filled.
Is there a way to do this in excel? If there is, could someone possibly turn me in the right direction (or assistance) with inputting this?
View 9 Replies
View Related
Aug 21, 2009
Private Sub txttodaysdate_change()
txttodaysdate = Format(Now, "mmm/d/yy")
End Sub
when i use this code i wnat the date to automatically appear in the text box but it doesn't I have type something into the textbox then the current date appears,.
View 4 Replies
View Related
Jan 9, 2013
I'm trying to make a macro that match table in sheet "Vocabulary" to the second table (columns Q,R,S,T) in sheet "Overview" and compute correct values in column U using weights from column F, sheet Vocabulary on values from a corresponding cell at column M, sheet Overview. The entries for every ISIN in the sheet Vocabulary are in no particular order and some positions from sheet Overview don't have to exist in Vocabulary at all (but I still need them to display in the table on the right to be able to make charts from summing these categories).
Portfolios.zip
How should the end result look like is displayed on the last sheet.
View 1 Replies
View Related
Oct 24, 2007
using the ttest formula function
View 2 Replies
View Related
Dec 13, 2012
how to compute for staffing requirement with turnaround time?
View 2 Replies
View Related
May 15, 2012
I have some question regarding elapse time using excel formula.. Just want to compute for the total hours consume by a person per task assign base on 5 days,8 hours per day working schedule(Saturday and sunday is not included since it is the restday of the agent. Working hours is 8am to 5pm. 12pm -1pm is the time agents take there lunch.
See below example and expected Result:
AGENTSStart timeEnd timeExpected Result(hour)RemarksCHARICE5/14/12 8:00 AM5/14/12 3:00 PM6.00Result subracted by 1 1hr breakALICE5/15/12 8:00 AM5/17/12 3:00 PM22.00Result subracted by 3 1hr breakJAKE5/16/12 8:00 AM5/21/12 3:00 PM30.00Result subracted by 3 1hr break(Saturday and Sunday is not included(may19-20))JOHNNY5/14/12 8:00 AM5/17/12 3:00 PM30.00Result minus 4 1hr break
View 9 Replies
View Related
Jul 25, 2013
Is it possible to show "0" zero in the total average column without inputing zeros in the blank cells in row B3:E3 & B4:E4? There are months we receive no boat & RV orders, so those months wll be zero most of the time. Instead of having #DIV/0! it show 0, without having to input zero in cells to compute the average.
A
B
C
D
E
F
1
Jan
Feb
Mar
April
Total Average
[Code] .......
View 1 Replies
View Related
Dec 17, 2009
I've just been asked to do a new Quality Control project for my boss. What I'm looking to do is be able to input the thickness values of our product in one worksheet, and have it recorded in another, as well as have the data separated by the model number
The main problem I'm having is figuring out how to enter data in the 1 worksheet as a template, and have the data consecutively stored, one after the other
Are there any functions that will allow me to do this?
View 6 Replies
View Related
Dec 28, 2007
way to 'insert' a formula into a specific range of cells using VBA only when the Value of $A$7 is changed to a value that does NOT equal "Custom".
Heres what I have so far using Worksheet change event....
View 10 Replies
View Related
Oct 12, 2008
on sheet1 which is called working sheet and cell d25 is asking what type of goods been sold
i have several different sorts"
ie
s25
s28
s50
s69
s70
s82
abd
t70
t140
i want the spreadsheet to look up somewhere on a sheet called delivery all the components that could be used for that type
so i guess i need to name define?
ie if s25 is selected
on delivery sheet in a20 it would then list all the components underneath each other.
View 14 Replies
View Related
May 6, 2009
I discovered this sample database sheet (attached) on the forum I wanted to ask if a picture can be linked included? i.e. when entering a new record a picture (stored in a directory) can be added and linked to that record. Then when reviewing the records the picture is then displayed.
View 6 Replies
View Related