software

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
quot;Croppingquot; to appear in A12.

Is the IF formula function the best for this?

Any help would be much appreciated.

=IF(AND(C7=quot;Potatoesquot;,C10=15),quot;Croppingquot;, ...)

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;stumakkerquot; gt; wrote in message
news
gt; Hi
gt;
gt; Is it possible to have a word appear in a cell if firstly a word is typed
gt; into another cell and a number is selected in another cell.
gt;
gt; E.g: If C7 has the word Potatoes in it, and C10 has 15 in it, can I get
gt; quot;Croppingquot; to appear in A12.
gt;
gt; Is the IF formula function the best for this?
gt;
gt; Any help would be much appreciated.
Thanks very much. Is it possible to have C10 as a range such as 10-20, rather
than just 15?

Thanks again

quot;Bob Phillipsquot; wrote:

gt; =IF(AND(C7=quot;Potatoesquot;,C10=15),quot;Croppingquot;, ...)
gt;
gt; but this will fail if you have too many alternatives (gt;8)
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;stumakkerquot; gt; wrote in message
gt; news
gt; gt; Hi
gt; gt;
gt; gt; Is it possible to have a word appear in a cell if firstly a word is typed
gt; gt; into another cell and a number is selected in another cell.
gt; gt;
gt; gt; E.g: If C7 has the word Potatoes in it, and C10 has 15 in it, can I get
gt; gt; quot;Croppingquot; to appear in A12.
gt; gt;
gt; gt; Is the IF formula function the best for this?
gt; gt;
gt; gt; Any help would be much appreciated.
gt;
gt;
gt;

Yes

=IF(AND(C7=quot;Potatoesquot;,C10gt;=10,C10lt;=20),quot;Croppingquot;, ...)--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;stumakkerquot; gt; wrote in message
...
gt; Thanks very much. Is it possible to have C10 as a range such as 10-20,
rather
gt; than just 15?
gt;
gt; Thanks again
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; =IF(AND(C7=quot;Potatoesquot;,C10=15),quot;Croppingquot;, ...)
gt; gt;
gt; gt; but this will fail if you have too many alternatives (gt;8)
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from the email address if mailing direct)
gt; gt;
gt; gt; quot;stumakkerquot; gt; wrote in message
gt; gt; news
gt; gt; gt; Hi
gt; gt; gt;
gt; gt; gt; Is it possible to have a word appear in a cell if firstly a word is
typed
gt; gt; gt; into another cell and a number is selected in another cell.
gt; gt; gt;
gt; gt; gt; E.g: If C7 has the word Potatoes in it, and C10 has 15 in it, can I
get
gt; gt; gt; quot;Croppingquot; to appear in A12.
gt; gt; gt;
gt; gt; gt; Is the IF formula function the best for this?
gt; gt; gt;
gt; gt; gt; Any help would be much appreciated.
gt; gt;
gt; gt;
gt; gt;