Perform a function if value exists within predefined range

[bond002]

Hi,

I need to perform a function if the value exists witin a predefined range. In matlab you'd probably use ANY but I cannot find an equivalent in excel.

Any help or suggestions will be greatly appreciated!

Many thanks,
Bond002

[NBVC]

something like?

=IF(COUNTIF(A2:A11,B2),your_formula,"")

[edvwvw]

Having reread the question - I have not given a solution that would work.

See NVBC above

edvwvw

[bond002]

Thanks guys.

It's not that simple and I guess I should've been a bit clearer.

NBVC: I tried the countif but it performs a true function regardless of the value existing or not exisiting within the range.

edvwvw: The range of values is much bigger than the one in the example and it consits of different values (not necessarilly between 1 and 10 only). It could be, say 1,3,4,5,7,10,12 etc.

Any ideas how to solve this?

Cheers,
Bond002

[NBVC]

My formula is in C2.

Change your number in B2 to 2, for example and see the result in C2.

[bond002]

Works as a charm. Thank you!
I have no idea why it didn't work when I tried this the first time. Must have made a typo in the formula.