software

How would I write the IF formula the do the following:

If the value of cell A2 = quot;Joequot; then populate cell F7 with the value found
in cell O1

Sorry. Let me rephrase this properly

If the value of cell A2 = quot;Joequot; then populate cell F7 with the value found
in cell O1 but if A2 =quot;Jimquot; then populate cell F7 with the value of P1quot;M Enfroyquot; wrote:

gt; How would I write the IF formula the do the following:
gt;
gt; If the value of cell A2 = quot;Joequot; then populate cell F7 with the value found
gt; in cell O1

Enter this in F7:

=IF(A2=quot;Joequot;,O1,IF(A2=quot;Jimquot;,P1,quot;quot;))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;M Enfroyquot; gt; wrote in message
...
gt; Sorry. Let me rephrase this properly
gt;
gt; If the value of cell A2 = quot;Joequot; then populate cell F7 with the value found
gt; in cell O1 but if A2 =quot;Jimquot; then populate cell F7 with the value of P1
gt;
gt;
gt; quot;M Enfroyquot; wrote:
gt;
gt; gt; How would I write the IF formula the do the following:
gt; gt;
gt; gt; If the value of cell A2 = quot;Joequot; then populate cell F7 with the value
found
gt; gt; in cell O1