Formula for data range

[ernie - willcox]

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

 

[Trevor Shuttleworth]

One way:

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

Regards

Trevor

 

[ernie - willcox]

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]

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

 

[David Biddulph]

Also perhaps http://office.microsoft.com/en-us/excel/CH062528191033.aspx for
functions,
and http://office.microsoft.com/en-us/excel/HP052001271033.aspx for example
formulae?