ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help on: IF no "," found in cell then... (https://www.excelbanter.com/excel-discussion-misc-queries/194838-help-if-no-found-cell-then.html)

David P.

Help on: IF no "," found in cell then...
 
I need help on an IF function. Basically I want to do this:

IF "," is not found in A1, then...

I've left out the part of the IF function I know how to do so as to not give
irrelevant information. Many thanks.
--
David P.

Bob Phillips

Help on: IF no "," found in cell then...
 
=IF(ISNUMBER(FIND(",",A1)), ...

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"David P." wrote in message
...
I need help on an IF function. Basically I want to do this:

IF "," is not found in A1, then...

I've left out the part of the IF function I know how to do so as to not
give
irrelevant information. Many thanks.
--
David P.





All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com