IF formulas

S

stumakker

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

Bob Phillips

=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)
 
S

stumakker

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

Thanks again
 
B

Bob Phillips

Yes

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top