User Profile
Bennadeau
Iron Contributor
Joined Jun 18, 2020
User Widgets
Recent Discussions
What is "OfficeShredderWacClient"?
Hi, Apologies if this is posted in the wrong hub. Looking at the Sign-ins monitor in Azure AD, I noticed one of my users gets a Successful sign-in every half hour. The application is "OfficeShredderWacClient". Anyone knows what that application is and what it does? This happens day and night and I know the user is not working at night. Did a google (ahem, I mean Bing) search and I can't find a concrete answer. Any help will be much appreciated. ThanksRe: If Formula
Hi TurkiAlhamed, One of the problem with your formula is that you set the "else" portion of all your "IF" to "0". Instead, the "else" portion should be the next "IF" (hopefully it make sense) =IF(AND(K13>=5,K13<10,D8<2000),D8*3,IF(AND(K13>10,K13<15,D8<2000),D8*4,IF(AND(K13>=15,D8<2000),D8*6,IF(AND(K13>=5,K13<10,D8<2000,D8<5000),D8*2,IF(AND(K13>10,K13<15,D8<2000,D8<5000),D8*3,IF(AND(K13>15,D8<2000,D8<5000),D8*4,0)))))) That said, the last 3 "IF/AND" are evaluating cell D18 to be lower then 2000 and lower then 5000. If D18 is lower then 2000, consequently it is lower then 5000 so you don't need to check the lower then 2000. Here's a revised version of your formula with this adjustment... =IF(AND(K13>=5,K13<10,D8<2000),D8*3,IF(AND(K13>10,K13<15,D8<2000),D8*4,IF(AND(K13>=15,D8<2000),D8*6,IF(AND(K13>=5,K13<10,D8<5000),D8*2,IF(AND(K13>10,K13<15,D8<5000),D8*3,IF(AND(K13>15,D8<5000),D8*4,0))))))Re: Formula error in link to another spreadsheet
Gary_Bostock It seems like a simple vlookup would do the trick here. =VLOOKUP(A47,'[LISTING 2020.xlsx]Sheet1'!$A:$B,2,0) Change "sheet1" for the sheet name where your data is. Change "$A:$B" for where your table is. This reads: "Find the value located in A47 within column A of Listing 2020.xlsx, sheet1. Then return the value located right next to it (in column B). I hope this helps.Re: Excell
Hi Patrice355, To rename a column, select the column header and hit "F2" on you keyboard. This will put your cell in Edit mode and you can modify the text. You can also just start typing without hitting "F2". In excel, you can use =hyperlink function. "=hyperlink(link location, friendly name)" See example below. This will make a hyperlink to google but will only show the word "search". =HYPERLINK("www.google.com","search") And I don't know about SqareSpace blog so I can't help with that.Re: Excel recording everything I type - Possibly something to do with Sheet Views
Hi Will_Peddie That's an interesting issue. Does it happen where ever you type or just in a specific cell? Does it happen in the same spreadsheet if you copy it to another computer? Does it happen with every spreadsheet or just a specific one? Can you share your spreadsheet to help troubleshooting?
