Correct Function to Use
in Colum A row 4 I have the word John or Fred or what ever and i want in
colum b to have a function that tells me A4 is John or fred or whatever i have there. |
Correct Function to Use
In B4 enter the formula
=A4 If this post helps click Yes --------------- Jacob Skaria "Confused novice here AGAIN" wrote: in Colum A row 4 I have the word John or Fred or what ever and i want in colum b to have a function that tells me A4 is John or fred or whatever i have there. |
Correct Function to Use
The formula you need is =A4
-- David Biddulph Confused novice here AGAIN wrote: in Colum A row 4 I have the word John or Fred or what ever and i want in colum b to have a function that tells me A4 is John or fred or whatever i have there. |
Correct Function to Use
"Confused novice here AGAIN" wrote:
in Colum A row 4 I have the word John or Fred or what ever and i want in colum b to have a function that tells me A4 is John or fred or whatever i have there. If you simply want to copy A4, then in a cell in column B: =A4 But if you want to test the contents of A4, then in a cell in column B: a. If you simply want to test for one name, for example Fred: =if(A4="Fred",true,false) or simply: =A4="Fred" b. If you want to test for any one of a set of names, then: =if(or(A4={"Fred","John","whatever"}),true,false) or: =or(A4={"Fred","John","whatever"}) |
All times are GMT +1. The time now is 01:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com