IF formulas
 

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.

IF formulas
 

=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.

IF formulas
 

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.

IF formulas
 

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.