If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula for returning a yes or no answer
Can anyone tell me what the formula is for returning a answer of yes or no, i.e.
you have a list of cars and you want to mark all the ford cars with a yes and all other cars as no. |
#2
|
|||
|
|||
Formula for returning a yes or no answer
bonny, something like this, with list in column A put this in A1 and copy down =IF(A1="ford","yes","no") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address to reply by email ** "Bonny" wrote in message ... Can anyone tell me what the formula is for returning a answer of yes or no, i.e. you have a list of cars and you want to mark all the ford cars with a yes and all other cars as no. |
Thread Tools | |
Display Modes | |
|
|