turn on suggestions

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

Showing results for

- 140K Members
- 4,185 Online
- 34.6K Conversations

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

Showing results for

1256 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 | ||
---|---|---|

Hello, is it possible to run this formula =RIGHT(N10,LEN(N10)-SEARCH(" ",N10,1)) and if it shows an error #VALUE! run an alternative version of the formula =RIGHT(B2,LEN(B2)-SEARCH(" ",B2,1))
Thanks, Read More | ||

Hello,
I am facing a problem writing some formula equations in Excel to solve them with Solver.
When I write the formulas of the equations:
lnx+x2-2x=0 lnx-ex-3x=0
It appears an error message:
I tried to modify options in Excel as indicated in the gu ... Read More | ||

Hi,
I am trying to write a formula based on 3 different types of variables. I started by using an extremely long If(and statement and eventually excel wouldn't let me keep going. You can see what I was typing in the sheet I attached.
I believe that I need ... Read MoreBrady,
=SUMPRODUCT(CHOOSE(BE2,assumptions!$C$4:$I$7,assumptions!$C$10:$I$13)*(assumptions!$B$4:$B$7=R2)*(assumptions!$C$3:$I$3=I2))*BA2 Hi Brady,
Please test this formula: =INDEX((assumptions!$C$4:$I$7,assumptions!$C$10:$I$13),MATCH(R2,assumptions!$B$4:$B$7,0),MATCH(I2,assumptions!$C$3:$I$3,0),BE2)*BA2 And ... Read More | ||

I am trying to get the date/time that a cell changes but not have it autoupdate....
Using this: =IF(B2 <> "",NOW(),"Not Checked Out") works until you update the next row an hour later then everything changes to the current NOW date/time. I can't use "TODA ... Read MoreHi Jennifer
Here you go: 1. open excel 2. go to: 3. in popup window go to : 4. Check 5. Change the value of Hello,
what you want to achieve cannot be done with the NOW() formula. It will always update to the current date and time. If you want a time stamp that does not change ... Read MoreBest Response confirmed by Jennifer Clark (New Contributor)
| ||

I have tried to use the Hlookup without success. I am looking for the formula which will populate the Which School column with the appropriate colum that has the street name in. I keep getting a #N/A in the second column.
Hi Mark,
In this situation, the most appropriate formula is this: =INDEX($C$1:$E$1,MATCH(A2,C2:E2,0)) Please find it in the attached file.
| ||

Good day,
I'm looking for a way to convert numbers(which inside a single cell) into words. I search the net and found this code: ============================================================== Option Explicit Sub SetNu ... Read More | ||

I have a spreadsheet with 50k+ rows. When I "sum" an amount column, I get different results if the spreadsheet is sort differently. I would expect the results to be the same regardless of the sort pattern. Any suggestions? | ||

Hello guys,
I would like to receive some help from you, as i cannot understand why my formula works for some values and for others isn't.
So, in date1 column, i have a formula applied to a previous column, which deletes CHAR160 from the previous column wh ... Read Morecan you try with this
=IFERROR(DATEVALUE(B2)+TIMEVALUE(B2),TEXT(B2,"General")) | ||

I am trying to create a formula that allows the table above. I have used IF commands and reviewed many tutorials, but I can not get the number after the manually entered RX number to stay in sequence with the number above the manually entered RX number. ... Read More
That worked perfectly! Thanks so much. I was trying to do it all in one column, which is probably why I couldn't get anything to work for me! I appreciate your help.
This formula.
IF(A2="",220000+ROWS($220001:220001)-COUNTA($A$2:A2),"")
please open attached sample file with data and formula. Read MoreBest Response confirmed by Jamil Mohammad (MVP)
| ||

I have an excel file with roughly 15k records and I have several different date formats showing up in my date column. The information comes from a variety of different sources, and this is why I have several different date formats. While I am working to m ... Read MoreThank you both for your responses. Greatly appreciated. Hi Dave, To convert dates select the column with them, in ribbon Data->Text to columns, parameters on first two steps of the wizard doesn't matter, on third step select D ... Read MoreBest Response confirmed by dave zwierecki (New Contributor)
Hi,
If you have all 15k records in the format of mm.dd.yy (separator is not a matter).
1. Make sure that your system date format in "mm/dd/yyyy". Try Find and Replace. Coz ... Read More | ||

I'm trying to setup a stock in and out spreadsheet with a master sheet that will have all the values automatically calculated. I need help on the formula that will look for the 'sku' in the other sheets and give me the value right next to it. i.e if i typ ... Read MoreHi Hagop Ipdjian,
From above i understood that, you have a 'ABC UK' named sheet with Column J having fruit names & Column K having numbers.
I can't under stand what 'sku' ... Read More | ||

I've gone through other threads and websites trying to understand how the IF statements work, but I just can't get my head around it. I need to try and apply IF statements to the following table and get a final price out of it in a single field. Anyone wh ... Read More | ||

Hi
I am trying to write the formula =IF(D4:D11>=3,"Contact Procurement Services"," ") however it is not working.
I have changed this to =IF(D4>=3,"Contact Procurment Services",IF(D5>=3,"Contact Procurement Services",IF(D6>=3,"Contact Procurement Service ... Read MoreSeja,
it is not clear what do you want to fix. A simple version of your formula would be: =IF(COUNTIFS(D4:D11,">=3"),"Contact Procurement Services","") Read More | ||

I have an excel sheet that i use to quote jobs. It has several boxes that all bounce equations off each other. When i open the sheet i create this perfect sheet, but when i close and reopen, everything changes. My formula is no longer valid because connec ... Read MoreIf you upload a sample of the file, maybe we can have a look and see what the issue might be? Cheers Damien | ||

Hi All,
The table below probably explains it best, however, I am trying to consolidate the unique values in column C against the common value in column B then populate the consolidated data into column D separated with a /. If the data in column B also ex ... Read MorePeter,
{=IF(COUNTIFS($E$3:$E$5,A3),"Direct"&IF(B3="","","/"),"")&TEXTJOIN("/",TRUE,IF(($A$3:$A$12=A3)*($B$3:$B$12<>""),$B$3:$B$12,""))} Read More | ||

Hi,
I am having a weird problem with Excel 2016. I am trying to make a very simple formula as shown in the screenshot below. I I have looked at various Excel guides and copied the simple formula, but as seen above, my Excel 2016 (sorry it's in Finnish but ... Read MoreHi Juho,
For Finnish version the formula is =JOS(F4>80;"Yes";"No")
Best Response confirmed by Juho Leppänen (New Contributor)
| ||

I need the formula that will allow me to say If Cell X isnot blank then return now() for true or "Not Checked out" for false.
=IF(B2 <> "","Date","Not Checked Out")
I can't figure out how to get the "True" to return Now() or Date() Read More
@Haytham Amairah Question - HOw do I get the NOW() function to stay static and not auto-update? I want it to return the date/time of when we check something in but it kee...
Read More
Hi Jennifer,
Simply, replace this: =IF(B2 <> "","Date","Not Checked Out") With this: =IF(B2 <> "",NOW(),"Not Checked Out") Or this: =IF(B2 <> "",TODAY(),"Not Checked Out") Read More Best Response confirmed by Jennifer Clark (New Contributor)
| ||

=if(M7>=90,A,if(M7>=80,B,if(M7>=70,C,if(M7>=60,D,if(M7<=59,F))))) I need a formula for this Hi,
You have to wrap each letter A, B, etc with double quote "<letter>" as follows: =IF(M7="","",IF(M7>=90,"A",IF(M7>=80,"B",IF(M7>=70,"C",IF(M7>=60,"D",IF(M7<=59,"F")))))... Read More | ||

Okay folks here is what I'm trying to accomplish. I have a summary sheet (Sheet 1) that I would like to retrieve data from another sheet (Sheet 2). The data in sheet 2 is comprised of multiple currency values, percentages, blank cells, and N/A cells). I w ... Read MoreBetter if you attach sample sheet to illustrate how your data is structured. - how do we know where are currencies in Sheet2? - would you like to find smallest in row, in ... Read More | ||

Hi, I would like to link 3 different formulas together, that allows me to edit the number without altering the formulas. For example, I want to link a formula to calculate cm, to feet, to inch and vice versa but a) I can't loop all 3 together, there would ... Read More
I'm confused! I "think" I know what you want but with a bit more info like a file attachment or a fuller description of what you've tried would be helpful.
Hi
You didn't show your formulas. It better be something with CONVERT().
| ||

Hello out there, can someone help me please.
I have som problems with a excelfile where i work in one sheet and read to another sheet. I write i one cell for example "Sa" and the other sheet reads it to onother cell with the commando =.
After that i want ... Read More
Sub Macro1() | ||

Hello guys, i want to know the formula or function to use color in order to decide the number that would appear!
any help T.T | ||

Advanced: Formula to calculate elapsed time from 2 given time, based on a string which is not unique
## Formula to calculate elapsed time from 2 given time, based on a string which is not unique
## Dear All Excel Masters! | ||

Dear All Excel MASTERS, HLEP! Hi Behrooz,
Please try this formula: =IF(ISNUMBER(MATCH(A2,Sent!$A$2:$A$9,0)),... Read More Best Response confirmed by behrooz amiri (New Contributor)
| ||

Hello, I need help with some formulas for 3 columns on my spreadsheet. I need a formula that changes red when the date inside it is 3 years older than today’s date, but stays green when not. It also needs to change red when there is no date. When I say to ... Read MoreNoelle,
in your sample file you define the color YELLOW for information that is soon to expire. You need to clarify that. Is it a text "Soon to expire" or is it a date wit ... Read More |

Top Liked Comments

Share

Popular

Learning Resources

Programs

Values

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