turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- 198K Members
- 2,790 Online
- 49.7K Conversations

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

4997 Conversations

- Mark all as New
- Mark all as Read
- Pin this item to the top
- Subscribe
- Bookmark
- Subscribe to RSS Feed
- Invite a Friend
- Sort by Conversation Start Date

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Custom List Message Item | ||
---|---|---|

Hi there, please can someone help? I'm using an absolute cell reference, but the formatting doesn't carry over... copy/paste? yes, but =acr as the result of an arithmetic function, no. (Excel 2013) Read More | ||

I am wanting to pull a report together that takes data in specified cells from four other tabs based on the content of an entry in a particular cell within the Report tab.
I'm not sure which is the best way to go about this or the formulae/macro to use. ... Read More Hey Katrina-
It would help if you used some sort of ID in the sheets with people that way if you have multiple cities on the list you can be sure to pull the correct en ... Read More | ||

I am working on a timekeeping worksheet that keeps track of anticipated vacation time. For each 7 hours of overtime worked, the time is kept in a "bank" to be used for vacation days. 7 hours of overtime equals one day of vacation. The formula looks at ... Read MoreHi Renee,
Please try this formula in column H. =IF(OR(D1>=7,D1>=14,D1>=21),"X","")
I hope I understand you well! Regards Read More | ||

Hello, I am creating an invoice report sheet and am looking at using IFS AND formula(s) to update a status column based on dates provided in multiple cells. looking for help with creating a single formula based on the below (if possible)... Criteria: - If $G6
Hello,
=IF(COUNT(G7:I7)=0,"Invoice not generated", Best Response confirmed by Philip Cassidy (New Contributor)
| ||

I have created a basic "movie draft" spreadsheet, where people pick movies and their box office totals are totaled up and the person with the highest overall total wins.
When I try to sort the leader board by rank (see attached spreadsheet) the SUMIF Form ... Read More | ||

Im working on a finance spreadsheet. I want a formula that would allow me to 'transfer' money from one budget item to another budget item.
For instance Cells Q12-42 (budget items) would look at Cells Y12 through Y999999 (Transfer from listed budget) and Z ... Read MoreHey John-
Hope you're doing well! Maybe try using a SUMIF() formula like the below example to solve your issue (See attached workbook for further reference):
Read More Best Response confirmed by john franklin (New Contributor)
| ||

I have a workbook that has about 10 worksheets. Each worksheet is a Departmental list of upcoming tasks. I need to create another worksheet that will look at each of the other worksheets and show me a list of all of the tasks that are within 30 days of ... Read More | ||

I'd like to use a simple COUNTIF function on a range of cells - the cells show either an 'M' (male) or 'F' (female).
However the values for those cells actually come from another tab in the worksheet so the cells I'm counting contain a formula to pick up ... Read MoreHi Angela,
Is that something like =COUNTIF(AnotherSheet!A1:A10,"M") or I didn't catch? | ||

Previous versions of Excel allowed me to write the following equation, "=SUM(B5-B4)/B4" now the version I have through Office 365 won't. Any suggestions?
Steven,
what do you me by "won't work"? Anyway, SUM() is superfluous.
| ||

I'm a school testing coordinator. I have an initial list of students with several descriptors.
What I want to do, is keep the above list as my original - then every so often, maybe monthly, I will take my current enrollment (with all their descriptors) an ... Read MoreWes-
Vlookup is indeed what you need. Based on the description of your scenario I think the below example will help you accomplish your task. I'm attaching an exampl ... Read More | ||

Hello Everyone,
I have a starting date (Sheet1!F8), and 2 dates to compare to (A6, and A7), If A6 or A7 is later than Sheet!F8, I want a name to display in the field (imported from Sheet1!F6). However, If A6 is later than the starting date, but A7 is stil ... Read MoreHi Martin,
It could be =IF(AND(A6>Sheet1!F8,OR(A7>Sheet1!F8,ISBLANK(A7))),Sheet1!F6,"") | ||

Hello Everyone,
I'm a teacher. I have multiple classes. Some have 2 times 40 minutes a week, and others 1 times 80 minutes a week. Per 80 minutes I do 1 lesson (A lesson is 1 Tab in Excel). In each lesson (tab) I have space for 2 dates (for the 40 minute c ... Read MoreDo you already have an excel file to show us? I'm trying to understand exactly what you need and I don't want to waste your time (and mine!) working on a useless predicti ... Read More | ||

I’m trying to display text from one page of a worksheet in a cell on another page, and have tried various things, but keep getting the error #NAME?
Please let me know if you can see what is wrong with the way I’ve written this function: =TEXTJOIN(“ “,TRUE,T... Read More Hi Beth,
If you change quotation mark symbol from =TEXTJOIN(Read More Hi, The arguments you have supplied to this function are correct, so I can only think of two reasons why you might be seeing a #NAME?
1) The first argument is not being re ... Read More | ||

playing with index match to learn excel, Hello,
Google and Excel are different products. Excel does not have an ARRAYFORMULA function. If you work with Excel, please stick to Excel. If you prefer to work with ... Read More | ||

Hello, How do I sum only the dollar amounts in a column that also contain text and other number values, such as percentages?
Hello, as a human being, how do you identify the numbers you want to include in the sum? Is there a pattern? How would you describe the logic in words? You need to give E ... Read More | ||

Hi Everyone! Hi,
You compare separately months and years. For next year month condition id FALSE and YEAR is TRUE, result is FALSE.
I'd suggest to compare full dates like =AND(H$4... Read More Best Response confirmed by Abhinav Gupta (Occasional Contributor)
| ||

Hi All, just like the title says I'm trying to develop a sheet where a series of formulas are updated when a single cell is given a value. essentially it's a numbering system based on some basic math:
I am creating data validation sheets for 20-digit barc ... Read MoreHi,
Not sure I understand your issue. If you use, for example, the formula =E41*2 it returns 512 in your case
| ||

My custom view is sorted on column B. After a new record is added, I need to manually initiate the sort. How can the resort be automated? Hi Gerald,
That's with VBA macro. See, for example, https://excelribbon.tips.net/T009006_Automatically_Sorting_as_You_Enter_Information Read More | ||

Hi,
I don't understand what is the operation that excel does when you have this list of number with conditional formating :
The rule for formatting is this :
But I don't manage to understand to what the percentage is referring (I try for the percentage o ... Read More
Very simple when it is written !! Thank you very much !
Hi Paul,
You min value is 200.1 and max one is 245.3. The difference is 45.2. 33% of it is about 14.92; 67% - 30.28
With your rule all values which are less than (200 ... Read More | ||

I have been trying for hours to figure this out with no resolve. In the cell I need the final number, I need to return either a zero value based on the number entered in one cell or the sum of a formula from another cell.
Cell M76. I need a formula that st... Read More It looks like =IF(M74=0,M73*17/390,0) for M76, assuming M74 is never negative. And what do you mean under the sum, with what?
| ||

Hi, am working on five columns. The first column is date, the second column is time in, the third column is time out. If I want the fourth column to to give a calculated value (time out minus time in) Something like the attached? Also can you clarify the part about the list of dates.
Do you need the weekday result not to show if the the date falls in the list? Read More | ||

Hi,
I want to create a formula for the below image where if the columns are marked with and X then the test price is added into the total cell at the bottom. Is this possible? Or something similar, its just to help view the costs quicker and hopefully elm ... Read MoreHi Kimberley,
It could be like =SUMIF(C1:C30,"X",B1:B30) | ||

Hi all, Hi Gyula,
IMHO, =SUMPRODUCT(COUNTIF(E2:CY3,A2:A1230)) shall return correct result, as well as equivalent array formula ={SUM(COUNTIF(E2:CY3,A2:A1230))} Read More | ||

It's been a little while since I've used Excel and I am having trouble writing out this formula. The formula has to follow these 3 criteria: Calculate each employee’s bonus amount on Tab 1 and enter the bonus amount under column named Bonus Received by fo ... Read MoreHi Marissa,
It could be =IF(A1>2080,250,IF(A1>200,A1/2080*250,0)) | ||

I am using the below formula:
I have attached ... Read MoreHi Sam,
Why don't you use something like =SUMIFS(Data!$C:$C,Data!$A:$A,C$1,Data!$B:$B,$A2) ? Please see attached. Read More | ||

I am using the formula below
=IFERROR(INDEX([170opscentre.xlsx]Sheet2!$C$2:$C$11,MATCH(B10[170opscentre.xlsx]Sheet2!$B$2:$B$11,0)),"") Works fine but is it possible to swap out the array (location on a shared drive) with a value contained within a cell? I ... Read MoreVLOOKUP($B2,INDIRECT(""&C$4&"!"&"B2:C12"),2,0) By Above formula you can lookup based your values in cell. If you want to learn more basic to advanced level concepts then y ... Read MoreHi Mark,
Yes use the indirect() function so your formula will look like this:
=IFERROR(INDEX("D1",MATCH(B10,INDIRECT(C1, TRUE),0)),"")
That should work for you.
Best Joe Read More | ||

Hello everyone. @Carl Purser wrote: It is way number five. Always. Read More | ||

Hi good day! I have a question if you can help me! May I know what'wrong with the formula. Thanks Hi, It is worth saying that the screen shot provided is from the "Get Started with Formulas" featured template that is provided by Microsoft and can be accessed from the F ...
Read More
Hi,
Your birthday label requires the anniversary birth date, not the original birth date.
So, try to input 03/29/18 instead. | ||

I am trying to use a formula to help differentiate whether an action has been taken. Like has this been scanned? yes or no (True or False) Can anyone give me some help? | ||

I have a very large database that needs to be split up in an interesting way and I can’t figure out how to word the question for google. Here is my best shot as a description.
I have rows with about 40 columns of data points. I need to take every row that I... Read More Let me ask what kind of datas are in the columns; if you have 40 columns and you have to make 8 new columns, it means that you want to merge columns 5 by 5; is that text ... Read More | ||

Hi,
I would like to search for the term"2008" on Excel but only on the "F" cell of the documment, but i don't know how to do that. | ||

When I add up formula results using auto sum on my computer no problem to get total.
A co worker sent me a file, I try to add up formula results and I get 0. If I change values to static it adds up fine. If I create a sum formula in another column and t ... Read More
Okay I figured it out. The cells I was trying to add formula results which contained a circular reference so it gave me a 0
Hi Steve,
It seems that the numbers you got from your co-worker are treated as texts not as numerical numbers.
However, one of the fastest ways to parse them and convert ... Read More | ||

Hello you lovely people. I am trying to add conditional formatting to a spreadsheet.
Excel 2013
In column F i have a date required, then in column H i have a date expected. I want to highlight the entire row if the expected date is greater than or equal t ... Read More | ||

Hello everyone,
I am trying to help a friend create her Excel sheet. We are both sort of new to Excel but eager to learn. I have something like that but: -I use google drive (modules) to insert new items to the list (you have to create a module asking for Day (if it's different from the date ... Read More | ||

Hello,
duplicating data in different sheets is not advisable. It's a lot easier to keep all data in one place and use a report or a filter to display only the data you ... Read More | ||

Hai,
I have some problem with formula in excel when i has 3 condition that need follow, Condition 1 : High <= 5, True, False Condition 2 : Medium<=20, True,False Condition 3 : Low<=30,True,False
I've try create this formula but cannot work. Anyone who can he ... Read MoreHello,
assuming the cell A1 has a number, try this:
=IF(A1<=5,"H",if(A1<=35,"M",if(A1<=55,"L","neither")))
In words: If A1 is less than or equal to 5, return the le ... Read MoreI don't understand what you're trying to do.
You can't use a formula like A1=M because M is not valid; if A1 can be the letter M you have to use A1="M" (with "). But if A1 ... Read MoreBest Response confirmed by Firdaus Ahmad (New Contributor)
| ||

Making progress, thanks to the help of the kind people here! I Have this formula: =IF(D1-C1<0,"",D1-C1) I'm REALLY proud of myself here, at this point! It worked properly.
However, when both C and D are empty, it displays #VALUE (I think it has a symbol wi ... Read MoreThe easiest way is simply to put SUM() around your cell references:
=IF(SUM(D1)-SUM(C1)<0,"",SUM(D1)-SUM(C1)) Hello,
if you want to check if both cells contain numbers, you can use Count(). Combine that with your existing condition like this:
=IF(or(D1-C1<0,count(C1:D1)=0)," ... Read MoreBoth empty: =IF(AND(D1="";F1="");"";IF(D1-C1<0,"",D1-C1))
At least 1 empty (and obviously also both): =IF(OR(D1="";F1="");"";IF(D1-C1<0,"",D1-C1)) Read More | ||

Hello,
I am trying to use the RATE function to calculate the rate of return on my savings but I keep getting an error. I am saving $100 every month and have been doing so for 14 months. I have currently $1,450 in my account. I am entering the parameters a ... Read MoreHi, The #NUM! error message you are seeing is because the PMT argument is not negative.It is important to remember that the signs (plus or minus) are very significant: A ...
Read More
n | ||

Hi, usually, if you type any formula with reference to another cell e.g. "=A4:A6" the fields which you are referring to, are marked in a colour.
However, this function is not longer working in my Excel 365. What can I do?
Thank you in advance! Read More | ||

Hi I'm trying to write an IF formula but use a range of numbers, for example: IF(M6>=15.4,"High 1st") but the range needs to cover 14.5-15.4. How d oI include this in the formula? Thanks Caroline Read MoreHi Caroline,
As variant that could be nested IF =IF(M6>=15.4,"High 1st",IF(M6>=14.5,"High 2nd","Low")) or LOOKUP =LOOKUP(M6,{0,14.5,15.4},{"Low","High 2nd","High 1st"})... Read More | ||

Hi all,
I am trying to create a spreadsheet to work out totals/percentages from an audit. I have got the basics done but have hit a snagging point where some of the answers are 'N/A'. If they are N/A then there is obviously no score, if it is not N/A then ... Read MoreHi Matthew,
Max total point available is the value against each audit point (i.e. N/A or 5 in each cell of the column), or that's one cell for entire section? Read More | ||

What's wrong with this? IFS(B="","",B=<>"",D5) Hi Patricia,
The cell references in your formula aren't complete, you cannot use only B, have to determine the number of the row as well, for example, B1, B2, B10 etc.
Th ... Read More | ||

Hi, I have a column that contains date values rounded with the INT function. My understanding is that these can be counted using the Frequency function but I am not getting the result I expect.
I would like to have an adjacent column indicate how many ti ... Read MoreJohn,
=IF(COUNTIFS(A$1:A1,A1)=1,COUNTIFS($A$1:$A$10,A1),0)
Or with FREQUENCY(): Select B1:B10, type in the formula and press CTRL-SHIFT-ENTER. {=FREQUENCY($A$1:$A$10,$A$1:... Read More Best Response confirmed by John Duff (New Contributor)
Hey John-
Not sure you need frequency to get the result you would like, but of course there is always more than one way "to skin a cat".... try using this formula and ... Read More | ||

Hello! Hoping someone can help me out.
I have two worksheets side by side... One has a master list of all invitees, the one beside it has the list of confirmed registrants. I'd like to create a row in the master list with a formula that populates "yes" or ... Read MoreHi Anna,
It could be like =IF(COUNTIF(<column with registrants names>,<invitee name>),"Yes", "No") Best Response confirmed by Anna Ianovskaia (Occasional Contributor)
| ||

I am looking for a formula that can take a start date and end date to calculate percentage then add a color to the grid below the date.
I did and this is the type of thing I am looking for, however I need the formula to incorporate it into a project sheet that is already being used. I cant seem to acquire...
Read More
Hey Terry-
have you taken a look at this Gantt Planner Template yet? Will it do what you would like?
https://templates.office.com/en-us/Gantt-project-planner-TM02887601 Read More | ||

Hello,
I am trying to calculate the number of interviews based on each Specific Region. There are going to be multiple responses for each interview, so I was looking to capture any cell that had data for that region. The data will be on tab 1, the resu ... Read MoreHey Danielle-
Hope you're doing well. Please try putting this formula in cell D3 of your worksheet:
=COUNTIFS(Sheet1!$C$10:$C$500, A1,Sheet1!$H$10:$H$500,"<>")
I b ... Read MoreBest Response confirmed by Danielle Manthei (New Contributor)
| ||

Need a formula to add (sum) a series of other calculations with a certain range. EX: =(M29*$M$7)+(N29*$N$7)+(O29*$O$7)+(P29*$P$7)+(Q29*$Q$7)+(R29*$R$7)+(S29*$S$7)+(T29*$T$7)+(U29*$U$7)+(V29*$V$7)+(W29*$W$7)+(X29*$X$7)+(Y29*$Y$7)+(Z29*$Z$7)........ Read MoreHi Lee,
Could be =SUMPRODUCT($M$7:$Z$7,M29:Z29) Best Response confirmed by Lee McKinney (Occasional Visitor)
| ||

Context: would like any CPT codes not on Medicare but on MCD100 identified Agnieszka-
Hope you're doing well. If you can provide a non-sensitive file with mock up data in it or a screenshot of your scenario it may help to better answer your q ... Read More | ||

I'm new to Excel so this may sound a bit simplistic. I have a list of organizational members with addresses, including states and zips. I want to know how many members reside in each state. How do I do that. Hi Gerald,
If you add names to your columns you may Pivot Table to calculate that, please see attached. | ||

Hello, I'm a beginner here. Is there a formula or function I can use (perhaps a =IF?) where I can make a certain formula's value appear in a cell only after a certain date? Hi Sam,
Yes, IF works. Concrete formula depends on your data structure, like =IF(TODAY()>DATEVALUE("2018-06-01"),<ref on the cell with May sum>,"") and date in your loc ... Read More |

Top Liked Comments

Share

Popular

Learning Resources

Programs

Values

- Contact us
- Privacy & cookies
- Terms of use
- Trademarks
- About our ads
- © 2017 Microsoft