=> function using named ranges

[wippa_dippa]

Hello!

I need to use a 'greater than or equal to' function using named ranges, as follows:

A range of column B cells is named 'apples'
A range of column C cells is named 'oranges'
A range of column D cells is named 'pears'
A range of column E cells is named 'bananas'
A range of column G cells is named 'stocknote'
- the cells in all of these ranges contain a number

I need to use the named ranges to create a function that basically says
"if the numbers in the named ranges of apples, oranges, pears and bananas are ALL equal to or greater than the number in the 'stocknote' range/column, TRUE= 'Fine' FALSE= 'Ask'.

Is this possible? I'm a bit bewildered by the whole thing!

Thanks for looking!

 

[Scott Huish]

Is this being done on a row by row basis or the entire set. If it's the entire set, unless you are using XL2007 or higher you can't use the entire column, so what would be reasonably the highest row you would need.

 

[wippa_dippa]

Is this being done on a row by row basis or the entire set. If it's the entire set, unless you are using XL2007 or higher you can't use the entire column, so what would be reasonably the highest row you would need.

Hi!

It's row by row, (if the apples, oranges, pears and bananas of a single row are equal to or greater than the 'stocknote' value of the same row, TRUE= 'Fine' FALSE= 'Ask')

Thanks for looking

 

[Scott Huish]

=IF(AND(apples>=stocknote,oranges>=stocknote,pears>=stocknote,bananas>=stocknote),"Fine","Ask")

Copy down.

 

[wippa_dippa]

Brilliant - thank you!