result

=IFERROR(O7-O6,"") Hello how can I avoid to see the result if there is no value in the cell of O7? The formula should give me result if there is number in the cell O7, is it possible?

Hello, This seems like a simple cell format issue but everything I have tried has not worked for me. I am using Office 365, I have 6 cells merged that display the result of an Index/match formula. This cell is formatted as a fraction but will only display a decimal number. I would like it to...

I have a column of numbers that come from a vlookup. I want to add this column up skipping the cells with a #N/A result from the vlookup. Thanks guys.

Hello guys, I've been having trouble getting global variables to work. Module1 code: Option Explicit Public Test As Variant Sub init() test = 2 Call testing End Sub Module2 code: Option Explicit Sub Testing() test = 3 End Sub All i want is to throw over my test variable value and update it...

Hi guys, Wondering if anybody a help with the following: I am currently using the following formula to return blanks when an error results from 'E25' being blank: =IFERROR(VLOOKUP(E25,'WORKSHEET'!$A$1:$S$1000,19,FALSE,"") However, when E25 is not blank but row '19' in '$A$1:$S$1000' has no...

Hello, I need help with this problem of finding the closest result based on 3 criteria. Using index and match I get the result but only if the result value and the variables are exact match. These are the measurements that I get from device: Variable_1 - B2=59.3 Variable_2 - B3=31.3 Variable_3...

Which uniform excel round off formula should I use to get the following result by multiplying certain figures by 2.57?: 6600*2.57 = 17000 7680*2.57 = 19700 11040*2.57 = 28900 12750*2.57 = 33400

Hi I need assistance to build a formula for the below scenario, BB,DN = HB BB,DN,LN = FB If cell A1 contains " BB,DN " I want the result to go B1 as " HB" and if cell A1 contains " BB,DN,LN" results to be in B1 as "FB" <tbody> <tbody> BB,DN,LN, FB BB,DN HB </tbody>...

hi, expert i need help the adjusted these codes i have userform contains textbox1,2,3 the textbox1 : Private Sub TextBox1_AfterUpdate() TextBox1.Value = Format(TextBox1.Value, "####.00") end sub and textbox2: Private Sub TextBox2_AfterUpdate() TextBox2.Value = Format(TextBox2.Value...

Hi Everyone, I'm a bit stumped on a formula I'm building. I am trying to return the close date for the 1st, 2nd, and 3rd Sales deal for all of my sales reps. I built out the following formula, which works if the sales rep has actually closed 3 deals. However, if the sales rep only closed 1...

Hi I understand how boolean variables work. However, I am looking for a simple code that use boolean to understand it better or to see how it is used really. I created the code below but to me that does not make a lot of sense, I have seen this example on the net. Sub myboolean() Dim...

i'm trying to do a sumif i tried attaching a photo but not sure it worked and don't want to attach my excel at the moment sumif(I:I,"1",(e119+J119)) The part in red is where I think i'm messing up. What I'm trying to say here is sumif the result in column I is "1" then sum these two cells.

Hello, I am hoping someone could help me clean up a formula of mine. I am looking to have the formula calculate between the current date and date received and then if this result is greater than 5 AND another cell ="0" return a "true" result, other wise "false". This is the formula I wrote...

Hello: This is my formula =[@[UPGRADE MRC]]-[@[CURRENT TOTAL MRC]] When the upgrade MRC cells are blank how can I make the result blank? In other words there would be no difference because there is no upgrade MRC. Do I need to add a , "" or a ISBLANK I tried ISBLANK and it produced false...

Hi All, Thanks in advance I have the following sheet Excel 2010 32 bit A 104 245 365 402 590 606 Sheet: Sheet1 Want the following result Excel 2010 32 bit ABC 10404 24545 36565 40202 59090 60606 Sheet: Sheet1 tried the following but not find the result 1)...

I need to look at data and return a list of unique numbers from column C where Column A, B match certain criteria. And a different set of returns where A,B, and D match certain criteria. I have data that basically looks like this: <tbody>#DAE7F5[/URL] "] A B C D 1 Criteria1 Criteria 2...

I have posted this on another board but I am now on a time crunch so I am grasping at straws. I would use a formula but this is something that will be used again and again by persons other than myself. I need to move the "-" from the end of the number to the beginning. I have cobbled together...

Hello I'm trying to do a sumifs formula based on 2 criterias. The first is a name. the second one I can't do is when the date DAY is lower than 15. For example in the table below I want to get the sum of A only lower than 15, the result should be 2.000 I was trying something (hardcoded just...

Good day MrExcel First off, thank you for taking this time to open and read up until this line... now my problem st I previously posted a question similar to this here in MrExcel and it was resolved by user <strike>AliGW. </strike>Now, I have encountered a project which has a different...

I have 2 columns (K and L) with the dates in the format: 08/27/2019 & 08/29/2019. I want to use a Concatenate formula to have the end result showing: Aug 27 - Aug 29. The formula I wrote is as follows: =CONCATENATE(TEXT(K3,"[$-409]mmm d;@")," - ",(TEXT(L3,"[$-409]mmm d;@"))) However this...