I have three quantities with prices:
30 - $6,313
100 - $5,592
300 - $5,261
I am trying to determine the price for each quantity in between the quantities above (31, 32, 33, 34, 35 etc).
Honestly I am completely stuck and any help is greatly appreciated.
i am trying to work out the difference of sales between current week and the week prior.
my formula so far is:
im struggling to work out how to compare it to the current week.
any help will be...
I am just curious how can i work around the formula such as when A1 is "100" (this is the maximum value), B1 is "110" and the excess of "10" is overflow to C1, while B1 is kept to "100"?
I couldn't find it anywhere else that solves this.
Your help would be greatly appreciated...
I am looking for a way to divide a fraction in one cell and put the percentage of that fraction into the next cell.
Example: B2- 36/164 C2- Percentage from B2 (36/164 = 21.95%)
Any help is greatly appreciated. Thanks.
Hope you can help; I need to work out formula for if cell A1 is greater than cell B1 then return value in cell A1 and if cell B1 is greater than A1 then return value of cell B1. Any help would be greatly appreciated.
I am looking to try and create a formula that counts occurances from a given date range >=20
So in month one the result would be 2 in month 2 the result =1
Your help is greatly appreciated
I'm trying to replace these bolded numbers...
=SUMPRODUCT(1/COUNTIF('Monthly Bills Rec''d'!F2:F5000,'Monthly Bills Rec''d'!F2:F5000))
With the COUNTA result from this formula...
COUNTA('Monthly Bills Rec''d'!A:A)
Any help on how to do this would be greatly appreciated.
What I'm trying to accomplish is this:
I have a customer field in C2. I'm trying to generate a specific hyperlink to different web pages in S38, based on the customer inputted into C2.
I tried using data to make a =Hyperlink(vlookup function, and it works. As I switch the customer name...
I have a large spreadsheet which I am working off (20+K rows)
The following is a formula which I wrote, but when I fill down, it takes a long time to process, so just wondering if there is a way to simplify it.
Any help would be greatly appreciated.
I created these formulas on a separate sheet and I need help with changing it so when the source sheet is filtered it only shows what is filtered and not all the data, any help would be greatly appreciated!
A7 31 . 13
A8 30 . 32
A5 * 30 . 41
A9 30 . 66
A8 * 30 . 06
A6 30 . 51
I have data which is formatted in a strange way.
There are spaces where you would not need or expect them to be.
Also there are some with * which is annoying because they are not
standardized to make it easy to extract the...
Hi, I'm having issues with the below. I'm trying to trimmean the weeks where the weekly number is greater than 5. I want to trim the mean to then exclude the top /bottom 10%. Below is the formula I currently have which I cannot get to work. Any help is greatly appreciated. Thanks...
I am having an issue with "Get External Data" from two different websites from the same vendor https://results.enr.clarityelections.com/IL/Will/95133/Web02.225997/#/ and https://www.dupageresults.com/IL/DuPage/94959/Web02.225997/#/. Currently, I am unable to figure out how to pull the data into...
So I am trying to figure out if there is a way to script from excel to run a report and extract the results from JDA. I know with other programs like SAP you can use GUI Scripting but can’t find much on JDA. Any advice would be greatly appreciated.
I am trying to sum the below based on how many months. I normally use a Sum INDEX but trying to build it into a SUMIF instead. My ideal result should be 9 but I keep getting 3. Is there a better way to do this? Any help would be greatly appreciated!
Please help. I need to put a formula within a formula. I have to create a table on y values for the formula y=1/2at^2 +vt when t is seconds and v is ft/s and given that a=32ft/s^2. T, and v are both numbers but a I'd another formula and I dont know how to put it in my formula for my table. Any...
hello yall Im tring to do a DV in VBA code where if A1=Yes then value in D1 must be between 1-120 and if value in A1=No then value in D1 must be between 121 - 150
Im thinking I need a DV in VBA Code. I already have a DV for D1 so I prefer a VBA.
Any suggestion is greatly appreciative.