Using IF statement with Spell check
 

Is there a way to use an IF statement to check words and denote if they are
spelled correctly? For Example, A1=cat; A2=dgo; A3=mouse.

B1=If(spellcheck(A1),1,0) yields a "1"
B2=If(spellcheck(A2),1,0) yields a "0"
B3=If(spellcheck(A3),1,0) yields a "1"

This would automate the checking of a column of words rather than stepping
through "IGNORE" commands using SpellCheck.

Using IF statement with Spell check
 

If you had a list of the correctly spelled words in a range of cells then
you could check them but this doesn't sound like what you want.

--
Biff
Microsoft Excel MVP


"Craig" wrote in message
...
Is there a way to use an IF statement to check words and denote if they
are
spelled correctly? For Example, A1=cat; A2=dgo; A3=mouse.

B1=If(spellcheck(A1),1,0) yields a "1"
B2=If(spellcheck(A2),1,0) yields a "0"
B3=If(spellcheck(A3),1,0) yields a "1"

This would automate the checking of a column of words rather than stepping
through "IGNORE" commands using SpellCheck.

Using IF statement with Spell check
 

Want to call for Spell check from within an IF statement. Doable??

"T. Valko" wrote:

If you had a list of the correctly spelled words in a range of cells then
you could check them but this doesn't sound like what you want.

--
Biff
Microsoft Excel MVP


"Craig" wrote in message
...
Is there a way to use an IF statement to check words and denote if they
are
spelled correctly? For Example, A1=cat; A2=dgo; A3=mouse.

B1=If(spellcheck(A1),1,0) yields a "1"
B2=If(spellcheck(A2),1,0) yields a "0"
B3=If(spellcheck(A3),1,0) yields a "1"

This would automate the checking of a column of words rather than stepping
through "IGNORE" commands using SpellCheck.

Using IF statement with Spell check
 

Want to call for Spell check from within an IF statement.
Doable??

No


--
Biff
Microsoft Excel MVP


"Craig" wrote in message
...
Want to call for Spell check from within an IF statement. Doable??

"T. Valko" wrote:

If you had a list of the correctly spelled words in a range of cells then
you could check them but this doesn't sound like what you want.

--
Biff
Microsoft Excel MVP


"Craig" wrote in message
...
Is there a way to use an IF statement to check words and denote if they
are
spelled correctly? For Example, A1=cat; A2=dgo; A3=mouse.

B1=If(spellcheck(A1),1,0) yields a "1"
B2=If(spellcheck(A2),1,0) yields a "0"
B3=If(spellcheck(A3),1,0) yields a "1"

This would automate the checking of a column of words rather than
stepping
through "IGNORE" commands using SpellCheck.