If the user selects, annual bill on the calculation type box:
1. Then I need the spreadsheet to use the figure 365 in cell G14.
2. I also need it to times the figure put into G15 by four.
3. It also needs to divide the readings in cells D9,D10,D11 by how many days in cell D7 and them times by 365 and put the answer in E9.
If the user selects bill to date on the calculation type box:
1. I need to copy the figure in D7 to G14.
2. The number in G15 needs to be divded by 90 and times by how many days in cell D7.
I've got a spreadsheet with several rows and the numbers within those rows are totalled up at the bottom. Is there a way where i can highlight the cell within the spreadsheet and it takes it off the accumulative total at the bottom? or something similar to this effect? I just don't want to have to remove figures from this spreadsheet and highlighting will be a good way of seeing what has been done
I'm trying to figure out a way to have a series of cells at the top of a spreadsheet that when a button is clicked, the data is sent to the bottom (or next available) open cells at the bottom of a table list. So essentially, a form that sends data to the bottom of a table or list.
I learnt that " " & can combine the text and figure. However, when it comes to a negative numbers, i dont know how to maneouver it. Eg, Cell A1 is USD(50,000.00) and the comment in Cell B1 is Cost is USD(50,000.00). So the function in B1 = "Cost is "& what to put here?
I am trying hard to use excel macro to round up cell value to next complete figure when it reaches to 0.6, however it should show the first five "0.1, 0.2, 0.3, 0.4, 0.5 exactly. I am giving increment of 0.1 digit to A1 Cell, it is going well. I am unable to get the next complete figure when 0.6 comes. Is it possible in macro.
I have 4 columns wherein the details are somewhat given below. Is there any way, wherein the figures under the column "No. of times" can be circled if it goes above 3.
Sheet1 CDEF19DateTimeMin.No. of times20Apr-0821Wed - 09-Apr-20082:42 & 2:494 & 23222Thu - 10-Apr-200803:215123Fri - 11-Apr-200810:27, 7:24 p.m., 7:39 & 7:401, 8, 1 & 12424Tue - 15-Apr-200810:26, 10:31, 10:32, 11:26 & 11:306, 2, 4, 4, 25 Excel tables to the web >> Excel Jeanie HTML 4
i have a figure of 1000 in cell a1. i want to divide it by a figure in cell b1 and have an answer in c1, or divide it by a figure in c1 and have an answer in b1.
in summary, cell a1 has i figure in it while cells b1 and c1 are empty until i enter a number into one or the other.
Cell B2 - this is a set figure which is the initial base figure - currently set to 43 Cell C2 - This subtracts Cell B2 figure (which is 43) from Cell E34 [=SUM(B2-E34)] Cell E34 - Is a cumulative total of 4 cells [=SUM(E4,E12,E19,E26)] and displays the total. Cell D2 is a set figure of 49
The formula I am looking for is once C2 reaches zero, I need C2 to remain displaying zero and the remaining figure to be deducted from D2 and displayed in that cell so C2 figure would descend from 43 until it reaches zero. but would then start decreasing D2 whilst C2 would remain static at zero and carry that the remaining figure to D2 which would be deducted from the starting total of 49 and display the figure.
Am after the code to change a cell colour if the value is a minus figure. There is a formular within the cell that can either equate to an positive or negative figure .. and would like the cell changed to RED if the figure returns a negative answer.
This is not related to macro - it's an excel question regarding wrapped-around text within a cell (i.e.: text brought onto next line by <Alt>+<Enter>)...
SayI have the following in a cell : Car<Alt>+<Enter> Truck<Alt>+<Enter> Van
and say I want to add a figure (in this example 1A) to the first part of the cell and then another to the second line of wrapped text and so on. How can I split the cell (or lookup the first 'wrapped' line) so that I can then perform changes (using formulas with '&' to combine etc or whatever) so that in the end cell have the following:
I'm trying to figure a to enforce dual data validation on a single cell. That is, I need to restrict the user to entering only a decimal value, only if a particular other cell (say A2) is blank. To put it another way, if A2 is blank, the user can enter a decimal value, but if A2 is not blank, the user cannot enter anything. I can use Data Validation to enforce either the decimal restriction or the ISBLANK, but I'm not sure how to make them work together.
i'm doing a process and in column N, i would need to have the following combinations:
A1 A2 C1 C2 H1 I1
so basically, a formula that would figure out the combinations available! can this be done using a formula?
******** ******************** ************************************************************************>Microsoft Excel - Cost Calculator---V5---Try.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutK39= KLMN39A12 40B 41C12 42D 43E 44F 45G 46H11 47I11 48J Cost Calculator [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
I have a command button (code listed below) which is 1/2 working. I have a column of PID's (numbers) sorted in ascending order which includes multiple rows with the same PID. When the command is executed, I want to insert a new row after the last matched PID (this part of the code works fine),
or
Insert a new row for the non-existent PID but in the correct sorted location (this is what I can not seem to figure out how to get to work).
I can successfully insert another line 158, or 159, but can not determine where to insert a line for PID 160 (which is not in the list yet)..................
I have this great code, but I can;t figure out how to add more columns to it.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column = 2 Then If Target.Value = "Q" Then With Target .Value = "" End With
Else With Target With Selection.Font .Name = "Wingdings 2" .Size = 22 End With .Value = "Q" End With End If Cancel = True End If End Sub
Here is what my table is im working with. The tite "todays date starts in Cell A1 and B1 is =Today().
I need to figure out how to do an if for the over 30,60,90 past due. Here the logic I need to figure out:
in the Over 30 column, the logic of the statement is as follows: If the difference between today's date and the date of the invoice is greater than 30 and equal to or less than 60, the amount goes into this column.(over 30 E3) To get the amount(the ammount in C3) into the Current column, the difference between the two dates must be less than 30. To get into the over 90 column, the difference between the two dates must be greater than 90. You can figure out the over sixty column. And this needs to be copied to the remaining colums
Today’s date: =TODAY() Shop Invoice Date Invoice Amount Current Over 30 Over 60 Over 90 Ludwig's Landromat =TODAY()-72 $432.78 Willie's Washing =TODAY()-107 $565.11 Wash It Here =TODAY()-80 $308.47 Spiffy Wash and Dry =TODAY()-58 $725.37 Water Soap & Hot Air =TODAY()-30 $427.95 Wash it & Dry it =TODAY()-90 $603.91 Acme Wash & Dry =TODAY()-60 $332.35 Totals
I have been building a tracker to track benefit payments for child benefits and DLA so I know where I stand and what has been paid.
The problem... its limited and basic an I have to do most things manually, even when I have cell formulas to do some of the legwork.
I stumbled across the term MATCH and SEARCH and I was curious on how to use them for my needs, I was trying to use the LOOKUP set of tools.
My problem...
Benefit rates are set between two date periods, all payment periods are 28 days apart (...but could change to every 7 days) which means that sometimes payments are due 3 weeks of one rate, 1 week of another, the reverse of that or 50:50 depending on the cycle.
A B C
[Code]....
The problem should be very evident and especially when I adjust the dates to match what payment dates I finally end up with.
The result of the look up needs to be calculated at the frequency in A14 to B14, A15 to B15 (for example) at the appropriate rate found in D:D when searched for based on the dates in A14 to B14 ... ... etc.
I tried using MATCH to get a match to a date falling between 30/12/2013 and 4/4/2014, I tried this...
I need to put together a list that shows (in total) how much candy everyone got. Sure, I could concatenate Susie & Bob's (and everone elses) lists, sort, duplicate, put a sum field into the duplicate list and delete repeat names, like...
nerds 4 oreo box 2 suckers =sum(!Sheet1,B3:B4) [or whatever the proper format looks like) tootsie-pop =sum(!Sheet1,B5:B6). But what if I have 15,000+ types of "candy"? It would be painful and tedious to put in all those sum fields.
This is almost embarrassing, but I have a simple VLOOKUP function that I can't seem to figure out. On Sheet2 cell A11 is the value I want to look up in Sheet1. Sheet2 B12 is the cell I am entering the VLOOKUP function. The value I want entered is in column 7 of Sheet1. I hope I have explained this enough. My formula entered is =VLOOKUP(A11,Sheet1!$A$9:$A$42,7,FALSE).
For whatever reason this is not working, and I am getting a #REF! error.
I am still new to VBA. I am trying to use VBA to search given rows for percentages above 0.81%. When it finds cells with percentages 0.81 and above it will high light the cell with red.
I work on a sea going vessel and manage an Emergency Response document. My dilemma is automatically assigning a Muster location based upon data entered in a certain column. I'm having a problem figuring out this Nested IF Statement: Column J will either be blank (no entry), "Fire" or "HRC".
If Column J is blank, column A needs to read "STBD". If column J has either "Fire" or "HRC" column A should read "PORT". See attached Excel file for an example with only 3 or 4 rows.
I've been unable to figure this out for the past few hours so I figure I better turn to.
I need to sum all "orders.price" on sheet 1 when,
1. SaleDate is within the two reference dates(basically monthly)
2. location field in sheet 1 contains the particular string of text
Using the filter function, I've narrowed down that the results of these are not correct at all.
The actual sales are consistent through the months, so each month should have a number in it, yet the worksheet results in almost all of the fields equaling zero.
