I want to check if cells C1, D1 and E1 contain the same name. For example if the cells all contain the 'Joe Bloggs' (or whatever the name variable happens to be) then cell F1 should say "Yes", else "No".
Anyone out there who can help? Much appreciated!
I am trying to write a formula that will test if a re-fi date is in an annual date range (eg. 01/01/xx-12/31/xx). I need it to return the remaining balance at different dates or "0" depending on the outcomes.
IF Re-Fi Date is > Annual period = Balance at the end of that year
IF Re-Fi Date is...
Hi,
Question 1.
I'm trying to build a data drop sheet. My goal is to create an if statement that reads the column headers and row headers. If both read a certain word "lets say a month & employee wage" then to return the value where they both intersect.
Question 2.
Same concept as above...
I am trying to figure out how to calculate an if statement using dates.
A2 = promised date
B2 = completion date
C2 = status
If the completion date is before the promise date then the status should equal = "on time"
If the completion date is after the promise date then the status should equal...
Good Afternoon Excel Experts!
I currently have a set of data that has two currencies: AUD and USD.
In this set of data i have many columns of locations and columns of pricing - the service to be provided is quoted in both AUD and USD for different locations. I would like to make this pricing...
Let's say...
i have a statement like =IF(AND((B4>=0),(B4<5)),"600" in cell D4.
Then i have =average(d4:d6)
it says, 600 in D4 when b4 is between 0 and 5 but how can i get that number to be calculated with other numbers. Its like it wont recognize the numerical value of the if statement to...
I am trying to do a formula collected from Cell A1 (% of target obtained) with the following below information
eg: 5 arguments:
IF <90% = -25% from A1
IF between 90% & 99.99% = "no bonus"
IF between 100% & 109.99% = 10% of A1
IF between 110% & 121.99% = 15% of A1
IF = > 122% = 20% of A1...
First I want apologize for what maybe the obvious, but I'm struggling with a formula and I just can't find the resolution.
My question is "How can I reference text conditions in one column, time conditions in another, and put out the True/False statement using an if function?"
Example would...
Hello,
I have a table of data, which is updated daily. This is a full upload, not delta. Against each line i have formula for various status, which are then returned in Pivot tables. All works well for the Business i am in. But i need to enter a IF combined with a VLOOKUP. I have not had a...
Hello -
I have two lists that I am working with - one that has the dimensions of a product and one that has the dimensions of the available shipping boxes. I need to compare the length, width and height of the product to the dimensions of the box and determine which box is the best fit.
I...
The following code is for degree-day calculation if anyone is familiar with it:
Function SinDD(Min1, Min2, Max, Base, Ceiling) As Double
'GDD Formulas from Allen 1976
Dim Taverage As Double
Dim W As Double
Dim PTheta1 As Double
Dim PTheta2 As Double
Dim Min As Double
Dim SinhalfDD As Double...
Ok all i have killed the brain today on this one and can not find anything out there on the internet that i can understand what they are trying to do and how they are coming up with solutions.
This is what i have:
A1 B1
Station Code
1220286.65 XR
1220329.70...
I am trying to create a excel formula where
if D1 is Y then A1=0
if DI is N then take info from F1
so the total equation not including the if statement above would be:
A1+B1+C1+N=
Afternoon,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
This one has been giving me nightmares, (Literary) all month.<o:p></o:p>
<o:p></o:p>
It is an IF statement which users ranges and arguments. I have similar, which works without...
Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p> </o:p>
I need a formula to help calculate the commission for my team at work. We are collectors and take credit card payments to clear up delinquency. Here is how the tiers work:<o:p></o:p>
<o:p>...
Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
I have an IF(AND... Statement that when FALSE, returns a blank cell. <o:p></o:p>
<o:p></o:p>
The trouble I am experiencing is using the cell with the IF(AND... statement in reference in a...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.