Hello Excel Gurus!
Thanks to anyone who can point me in the right direction.
I have been tasked to create a "smart" data collection form in excel 2010 where a user inputs collected info from a call. The form is divided into 5 main sections with as few as 6 and as many as 26 manually input...
Hi, </SPAN>
I am trying to work out the status of something based on a date, while first checking a column to see if something is complete.</SPAN>
=IF(L6>$L$4,"Pending","Expired") – This is in cell M6</SPAN>
L6 contains todays date</SPAN>
L4 contains the date a piece of work was due to be...
Hi,
I'm looking to write a nested IF formula which will be dependant on certain cells that have errors in them (because those error cells have a formula in them which can't formulate becuase the numbers needed for that formula haven't been entered yet).
For example.
Cell A1=#DIV/0!. Cell...
<tbody>
A
B
C
1
clothes
transportation
drinks
2
pants
car
coffee
3
shirt
train
tea
4
sweater
bicycle
juice
5
tie
plane
milk
</tbody>
Hello everyone,
I have been trying so had to make this work.
I want to return "category 1" if the text is found in...
I have been working on a spreadsheet on excel 2010 tracking the number of items a student can acquire. One student can have multiple teachers (uID). Items can be tested once or multiple times in a day. From columns A to E lists the raw data while column G contains filtered data of unique items...
Greetings all,
Long time troller, first time poster.
I'm building a spreadsheet that tracks total product packaging weight by multiplying packaging weight per unit by the number of units sold. e.g. 10grams of HDPE per unit x 1000 units sold = 10kg of HDPE.
I have a large worksheet with all...
Hello,
I'm stuck here.
Column G is people's names, columns I and J are dates, the formula I’m writing is in column R.
My desired end result is:
If column G contains the name “Ed”, column R should say “N/A”. However, if column G contains a name that is NOT "Ed" AND there are dates in...
Hi All
I have a spreadsheet with 2000 rows of information, What i am trying to do check the Numbers column if the cell values match and set the first time of call to 0 i:e the 0 to represent the initial call and then work out the time difference between additional calls in the time bucket...
Hi all,
I'm using Excel 2013 and I need a nested formula in a column of my worksheet but I just can't get around the right syntax.
I need the formula to do the following:
IF G4 = "TOR" and Q4 = "TO", THEN "Correct", else "Wrong"
IF G4 = "DMCR" and Q4 = "DMC", THEN "Correct", else "Wrong"
IF G4...
Hello,
I want cells that are
>=6 to be have a "P" instead in a different worksheet
3-5 to have a "F" instead in a different worksheet
<=2 to have a "G" instead in a different worksheet
But in my worksheet I have 0 and blank cells. I need the 0 to say "G" and the blanks to remain blank. I...
i have a formula that i want to increase the typed in date by a week, month, or year, but am having trouble putting in the "edate function
my formula is as follows:
=IF(F8="WEEKLY",I8+6,=IF(F8="MONTHLY",I8+30,=IF(F8="YEARLY",I8+365,"")))
i want to replace the +30, and the +365 with and edate...
Hi All
I am trying to produce a Resource plan which shows projects in Column A, then has 5 Stages for each project which contain a Project start date then at lest 3 items of data (Stage Lead (Name), Stage Finish Date, and Stage Resource). I need to create something akin to a horizontal stacked...
Hello All,
Looking for help with a formula. I have attached a sample data set (see below 4 rows) and will spell out the logic I hope to obtain. I can include further information if it is not clear what's trying to be accomplished. I have 4 validating criteria that have been provided weights. I...
I just can't seem to get this right.
I have two conditions,
Balance Days Action
>$1500 >1200 "Keep"
>$1500 <1200 "Remove"
<$1500 >840 "Keep"
<$1500 <840...
hi all
here's the situation:
a) if(client limit>x;if(utilization>client limit;calculation1;0))
b) if(client limit<x;if(utilization>x;calculation2;0))
i've tried to nest b) into a), in place of the value if: false (0) argument without success.
i dont have any VBA skills, so would prefer to use...
Hello!
I'm using a nested IF statement and calculating values based on the data in adjacent cells. I basically want part of my formula to do this check: If this cell isn't equal to #N/A, then display a certain value. Right now, my formula looks like this...
Hi,
I am having a few issues with the excel autofill function. Here is what I want it to look like:
<tbody>
A
A1
=IF(Sheet2!A1>=4,100,IF(Sheet2!A1=3,75,IF(Sheet2!A1=2, 50, IF(Sheet2!A1=1,25))))
A2
=-A1
A3
=IF(Sheet2!A2>=4,100,IF(Sheet2!A2=3,75,IF(Sheet2!A2=2, 50, IF(Sheet2!A2=1,25))))...
Hello all - I have an odd situation - making it even odder is the fact that a google search doesn't produce a million people having the same problem.
I have a calculated column with the following formula to identify outliers in contract values...
I've got an interesting one that I hope someone can help me with.
I have a spreadsheet with two drop-down lists and two cells to fill in and this populates data in a table so that a journal entry can be entered into the accounting software.
The drop-down lists consist of the following:
1. Type...
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.