How can I use the IF function, to make entering a word, space then word display correct and incorrect if not.
Many thanks
How can I use the IF function, to make entering a word, space then word display correct and incorrect if not.
Many thanks
Try inserting a AND function in your if statement...
=if(AND(condition1=word,condition2=blank,condition3=word),good job, bad boy)
Y
I mean in reference to another cell
Try to be more specific what you need ????
I have guess that you want as below :
Lets you have words in Column A and you can put this formula in column B1 and then drag it down .....
A1=HI
A2=BYE
A3=CALL
A4=TELL
now write below formula in B1
B1=IF(A1="BYE"," Correct"," Incorrect")
Now in your Cell B1 you will find " Correct"
B2= " Incorrect"
A person must type two words (identifiable by a space in between) in cell B3, if not cell D3 displays incorrect if they do write two words cell D3 displays correct.
try this.. this will give you true or false if there is no letter (or number) after space or space is in first place or no space at all
=ISNUMBER(FIND(" ";I12;2)+1)
Hi NatNat,
Probably you could use the following formula in D3
You can apply =trim(CellReference) and remove all the extra spaces.Please Login or Register to view this content.
Ok I will give it a go
Last edited by NatNat; 05-06-2009 at 05:11 AM. Reason: typo
Sorry NatNat,
Following formula will surely solve your problem
Just try it once.. and let me know how it works..Please Login or Register to view this content.
Regards,
Vaibhav
some minor change in Zbor formula as it will not work if we have a space before / after and not between ..... So trim will make sure that there is a space between 2 words ......
=ISNUMBER(FIND(" ",TRIM(A7),1)+1)
Yeah Vaibhav's solution answers the problem.
There is another way of doing it.
=IF(ISERROR(IF(FIND(" ",B3)<1,"Incorrect","Correct")),"Incorrect","Correct")
Hi Poojabans,
The formula that you have provided doesn't take care of many of the possibilities.. Though I dont know if they have to be considered..
See the attached file..
I think It depends on user, what he want as if you have one trailing space in the end of name then both formulas will say its true .......If we have first, middle & last name but one of the formula is saying its wrong .... ........
In database we can easily restrict user not to make mistakes but in excel its really hard .....
Hi mubashir,
thanks for pointing that out..
Hope this formula works in all cases..
Yes mubashir, you are correct that it is difficult to restrict a user in excel.. as in the coding required is much more than that required in a database..Please Login or Register to view this content.
but then excel has its own advantages..
Regards,
Vaibhav
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks