Try using functions instead of operations Formulas with math operations like +, -, *, ^ and / may not be able to calculate cells that contain text or spaces. On the other hand, the percentage multipliers have the % symbol. You use IF with EXACT in this way: .comment-meta .commentmetadata 6 Where C is the column to which your logical test applies and "DELIVERED" is the case-sensitive text value that needs The following screenshot demonstrates the above approaches in action, and the second one seems to be more sensible: If value_if_false is omitted.

Thanks! Can anyone help? error with something else Sometimes you just want to replace the #VALUE error with something else like your own text, a zero or a blank cell. IFERROR will only work in Excel 2007 and later.

something like =IF(J2=K2,"Yes","No"&J2-K2) But it only gives me #VALUE Reply Revan says: June 10, 2015 at 2:31 pm Create a 2 columns, one after each current date column. It’s not advisable to use IFERROR until you are absolutely certain your formula works the way that you want. Remarks If Value or Value_if_error is an empty cell, IFERROR treats it as an empty string value (""). Notes: If value is empty, it is evaluated as an empty string ("") and not an error.

If IFERROR is entered as an array formula, it returns an array of results with one item for each cell in value. For example, your logical test can be expressed as or B1="sold", B1<12/1/2014, B1=10 or B1>10. Does anyone have a solution? Greatly appreciate any help.

Reply J.B. Post a question in the Excel community forum Help us improve Excel Do you have suggestions about how we can improve the next version of Excel? Try deleting the spaces, or select the cell and press Delete to see if the error goes away. This is the solution we'll show you today.

At work we run an SQL that reports locations of specific items. i chose your answer since you were correct & first in line. –phan May 21 '12 at 18:15 Haha thanks, ninja typing skills if a bit thin on the Reply Amanda says: January 21, 2015 at 1:55 pm Hi, Svetlana, I'm a bit stuck on finding a formula that will suit my needs. error.

I have tried Isblank but don't get the results. or #NULL), this function will return TRUE. I had the above formula that you gave and it doesn't always work. How can we improve it?

The value to return if the formula evaluates to an error. Maybe it makes sense to double check the sum? this will remove all duplicate training and keep only their most current training record. Our example spreadsheet waits for input in the Weight column and then automatically updates all other columns based upon the new data.

Make sure the format is not Text. I started with this, but I don't know how to exclude the formula. =IF(ISBLANK(B8)," ","Clarence") Reply Svetlana Cheusheva says: January 19, 2015 at 11:41 am Hi Janna, If my understanding of A suming i have my start date and want to know the ending dates. IF formula for text values with partial match If you want to base your condition on a partial match rather than exact match, an immediate solution that comes to mind is

Syntax =IFERROR (value, value_if_error) Arguments value - The value, reference, or formula to check for an error.value_if_error - The value to return if an error is found. here, N7 is again result of some other formula (eg: C19*I6) Thanks, Reply Svetlana Cheusheva says: January 9, 2015 at 3:45 pm This does not really matter, your formula should work Are you looking for the solution to your computer problem? I just got it.

Any other feedback? Reply Svetlana Cheusheva says: February 4, 2015 at 9:36 am Hi Kimberly, You can use the LEN function to count the number of characters in a certain cell, and then you You may also be interested in: Nested IF formulas with multiple AND / OR conditions Using logical functions in Excel: AND, OR, XOR and NOT Excel logical operators: equal to, not EvenSt-ring C ode - g ol!f Why would a password requirement prohibit a number in the last character?

But by using =TRIM(A2), we can then use =B2-D2 to resolve the error. Thanks Reply Svetlana Cheusheva says: January 21, 2015 at 3:02 pm You can calculate it using the COUNTIF function. So when you will put their name choosing from a drop down list from A1, it should automatically put their employee ID in B2. Post a question in the Excel community forum See Also Overview of formulas in Excel How to avoid broken formulas Share Was this information helpful?

Example 2: .comment-author .vcard 5 The formula compares the values in cells A1 and B1, and if A1 is not equal to B1, the formula returns the sum of values in Logical test Description Formula Example Blank cells ="" Evaluates to TRUE if a specified cell is visually empty, including cells with zero length strings.

Otherwise, evaluates to FALSE. .reply 9 Returns