Hi
I have been battling this one for hours!
I have two formulae one that looks down Column E for specific text that is held in cell G2, the second looks down the same ColumnE for specific text held in G3.
Both work well and return the value of the specific cell to cell E1.
I have been trying to...
Hi,
I have a nested if and I am trying to add an if error message and I am not getting the context right can you please help..
Basically
if there is an error in I3 return review,
If B3=nothing return nothing
if I is not greater than .01 or lessthan -.01 return review else nothing
Sample"...
Hello!
Wondering if could have feedback on writing a formula that excludes specific criteria from a list. I started a formula that saysIF(ISERROR(MATCH(cellA1,lookupcolumn,0))=FALSE.
I’m confused by ISERROR. That essentially returns true if there is an error or false?
I want to write a formula...
hello,
i would like to ask a question, regarding a problem i've faced recently.
I want to take out a specific information from a text, which varies, for example:
asdjhbasdas1234BGasdhasd - i want to take out and display just the 1234BG
iaiopsunlkas1234BGpiouqws- i want to take out and display...
Hi All
Im trying to add the ISERROR syntax to the start of this formula in order to eliminate any #values appearing to no avail
=IF(AND(L$5>=$C6,L$5<=$D6),$J6,"")*$K12
can anyone assist?
thanks
Hi Community,
I have a formula that is leaving me stuck and I'm not sure how to solve it and hoping you can help.
=IF(ISERROR(D50/D49),"BCB Auto-Fail",D50/D49),IF(AND($C$14,$C$18,$C$22,$C$26,$C$37,$C$40,$C$44)="---Select---","N/A")
Issue: the formula should be trying to calculate that IF...
Hi all,
I want to check the correlation between two columns (column B and I), taking out all the values that give an error. Furthermore if a certain nth value in column B (I) gives an error, the corresponding nth value in column I (B) should also be ignored. I did it this way but it gaves a...
Hey guys,
I have column with 500 repeated formulas.
The formula is
=IFERROR(IF('052'!E44="","",'052'!E44),"")
BUT....the E44 is different on each line with no sequential order. I need to remove the "IFERROR(" and ,"") from every line without effecting the IF formula criteria.
any help?!
Hello all.
Here is the scenario.
I am using Excel to track the inventory of desk phones(among other things)
This screenshot is row 8.
Here is what I currently have for the H Column
=IF(G8<>"",INDEX(AD_Username,MATCH(G8,AD_Locations,0)),"")
The phones are assigned to a particular seat or...
Hi!
I have an If function which examines a cell and if contains error, then gives a value of "1" to a cell in that row.
Code:
If IsError(Cells(k1, 5).Value) = True Then
Cells(k1, 8).Value = "1"
End If
https://imgur.com/a/SB5tEBE
But it doesnt work as expected: there is a "1"...
I have Make Table query that evaluates a field, replaces an undesired character ("*") with another ("_"). The replace function within the calculated field works correctly, however errors appear in the results. This creates problems down the line.
Is it possible to somehow exclude the errors...
I am trying to keep cells from having an error using iserror function . . . but I can't seem to get my arguments correct on the following:
=IF(AQ3<>0,INDEX(AL$3:AL$62,MATCH(AQ3,AM$3:AM$62,0)),"")
How would I write this using the ISERROR function to keep error out of cells?
Thanks in advance!!!
I've entered this bit of code into a macro and it's working ok:
ActiveCell.FormulaR1C1 = "=MID(R[0]C[-2],SEARCH(""Range"",R[0]C[-2])+6,1)"
however, when the cell doesn't have the word Range it returns a 'Value' error.
To overcome this I added an ISERROR function...
Hello Excel gurus. I have another wild project that I'm almost able to complete, but stuck on the last part. Previous posts have been resolved (with MUCH appreciation) by using the IsError formula to search an array of values and find matching values. Now the request is similar, with an...
Hello, I've been trying to figure out what formula to use so that when I input it in Sheet1 column B, it looks up the string "USERID1" in column A (the url) and matches it with column A in sheet 2, and the result is the value in column B (clientName)
Sheet1
<tbody>
Column A
Column B...
Hello,
I have VBA formula and I need to add If & IsError due to empty cells, I have tried
"=If(ISERROR(LEFT(RC[-1],FIND("", "",RC[-1])-1)),"",LEFT(RC[-1],FIND("", "",RC[-1])-1))"
But not working
Thanks for any help on this
Sub SplitColumn()
Dim ws As Worksheet
Set ws =...
Hi guys,
Please explain me what am I doing wrong with the following situation:
I have two tables, in both tables I have sim card numbers and according contact addresses. The reason why I need two tables is that in one of those tables, addresses are more fresh but the problem is that not every...
Hi Guys, I hope you are all well.
I was just wondering if anyone could help me on the below please
=IF(ISERROR(F2)=TRUE,"N/A",VLOOKUP('Hidden Sheet'!H2,'Hidden Sheet'!I2:J176,))) It keeps on erroring under #VALUE but I am sure I have covered my bases.
any help would be great
jamie
Hello,
I have looked hell over for a solution to my problem.
I have a matrix containing a column of text mixing dates and text. I want it so that my formula copies a cell to its left if it contains either monday, or tuesday, or any day of the week, and leaves the left cell blank otherwise. The...
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.