Problem with IF formula

		Microsoft Office Forums > Microsoft Excel > Excel
Problem with IF formula

FAQ

Thread Tools

Display Modes

05-10-2023, 11:46 PM

Pecoflyer

Windows 10 Problem with IF formula

Office 2021

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Try

Code:

=IF(A2="","",IF(ISNUMBER(FIND("?",A2)),LEFT(A2,FIND("?",A2)-1),A2))

If FIND does not find the value, it returns a VALUE error. Wrapping with ISNUMBER does the trick

Attached Files

Book1.xlsm (12.3 KB, 2 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Problem	CaronBaines	Excel	7	01-09-2017 05:30 PM
Formula Problem	pikerman	Excel	2	02-16-2015 01:38 AM
Problem with formula!	Victoria Linen	Excel	1	02-04-2014 01:10 PM
Embedded IF AND OR Formula Problem	J Morrow	Excel	9	08-26-2011 06:51 AM
Formula problem?	markg2	Excel	11	06-10-2010 07:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:12 PM.