If ..

J

jer

Is it possible to write an if statement that includes a
criteria, e.g.
if a1 does not contain "abc" then b1= 123
 
A

Andy Wiggins

In cell B1 put the formula:
IF(A1<>"abc",123,"A1 did not contain abc")

If you want to check if "abc" is within a string in cell A1, use the FIND
function to test A1's contents.

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
L

Leo Heuser

=IF(A1<>"abc",123)
The formula must be entered in B1. You cannot from
one cell alter the contents of another cell.

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Required 1
Merging cells and formats 8
Search Formual Error 4
VBA Coding Help for Beginner 0
if function, how? 4
Page numbering with Merged Document and IF statements 1
SUMIF with criteria "<>" & "=" 4
find and replace data 3

Top