Yes

=IF(AND(C7="Potatoes",C10=10,C10<=20),"Cropping", ...)


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"stumakker" wrote in message
...
Thanks very much. Is it possible to have C10 as a range such as 10-20,
rather
than just 15?

Thanks again

"Bob Phillips" wrote:

=IF(AND(C7="Potatoes",C10=15),"Cropping", ...)

but this will fail if you have too many alternatives (8)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"stumakker" wrote in message
...
Hi

Is it possible to have a word appear in a cell if firstly a word is
typed
into another cell and a number is selected in another cell.

E.g: If C7 has the word Potatoes in it, and C10 has 15 in it, can I
get
"Cropping" to appear in A12.

Is the IF formula function the best for this?

Any help would be much appreciated.