Formula for data range
 

I have a data row (K) that contains several numbers. For example.K2
contains the numbers. 61 62 63 64 65 66 67. K3 contains the numbers 64 65
66 67 68 ect... I'm sure there is a forumula that will allow me to say, if
K3 contains 67 then L3 = 67. When in this instance L3 would = 67. If the
data in K3 the numbers 69 70 71 then the return value would be "blank".

Make sense?

E

Formula for data range
 

One way:

=IF(ISERROR(FIND(67,K3)),"",67)

Regards

Trevor


"ernie - willcox" wrote in message
...
I have a data row (K) that contains several numbers. For example.K2
contains the numbers. 61 62 63 64 65 66 67. K3 contains the numbers 64
65
66 67 68 ect... I'm sure there is a forumula that will allow me to say,
if
K3 contains 67 then L3 = 67. When in this instance L3 would = 67. If the
data in K3 the numbers 69 70 71 then the return value would be "blank".

Make sense?

E

Formula for data range
 

Trevor, worked like a dream... You just saved me hours worth of looking... Is
there a page where a person can find a list of formula's for excel?

"Trevor Shuttleworth" wrote:

One way:

=IF(ISERROR(FIND(67,K3)),"",67)

Regards

Trevor


"ernie - willcox" wrote in message
...
I have a data row (K) that contains several numbers. For example.K2
contains the numbers. 61 62 63 64 65 66 67. K3 contains the numbers 64
65
66 67 68 ect... I'm sure there is a forumula that will allow me to say,
if
K3 contains 67 then L3 = 67. When in this instance L3 would = 67. If the
data in K3 the numbers 69 70 71 then the return value would be "blank".

Make sense?

E

Formula for data range
 

I think the easiest way is to click on the "fx" (insert function) icon on
the formula bar. Choose all functions and scroll through. Select a
function to see what it does.

You could also try the Excel Help but, in my experience, you need to know
what you are looking for before you look for it ... a bit like a dictionary,
really.

Regards

Trevor


"ernie - willcox" wrote in message
...
Trevor, worked like a dream... You just saved me hours worth of looking...
Is
there a page where a person can find a list of formula's for excel?

"Trevor Shuttleworth" wrote:

One way:

=IF(ISERROR(FIND(67,K3)),"",67)

Regards

Trevor


"ernie - willcox" wrote in
message
...
I have a data row (K) that contains several numbers. For example.K2
contains the numbers. 61 62 63 64 65 66 67. K3 contains the numbers
64
65
66 67 68 ect... I'm sure there is a forumula that will allow me to
say,
if
K3 contains 67 then L3 = 67. When in this instance L3 would = 67. If
the
data in K3 the numbers 69 70 71 then the return value would be "blank".

Make sense?

E

Formula for data range
 

Also perhaps http://office.microsoft.com/en-us/ex...528191033.aspx for
functions,
and http://office.microsoft.com/en-us/ex...001271033.aspx for example
formulae?
--
David Biddulph

"Trevor Shuttleworth" wrote in message
...
I think the easiest way is to click on the "fx" (insert function) icon on
the formula bar. Choose all functions and scroll through. Select a
function to see what it does.

You could also try the Excel Help but, in my experience, you need to know
what you are looking for before you look for it ... a bit like a
dictionary, really.

Regards

Trevor

"ernie - willcox" wrote in
message ...
Trevor, worked like a dream... You just saved me hours worth of
looking... Is
there a page where a person can find a list of formula's for excel?