Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simple formula
in cell A2 I have 2
If i enter a "yes" in E2 I want F2 to equal 2 (same as A2) I know this is simple, but I can't figure it out. Help. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simple formula
marley wrote:
in cell A2 I have 2 If i enter a "yes" in E2 I want F2 to equal 2 (same as A2) What if E2 is not "yes"? Learn to always specify the "otherwise" (else) case. For what you have specified thus far, in F2, write: =if(E2="yes", A2, "") The 3rd parameter ("") leaves the cell empty if E2 is not "yes". Fill in something else appropriate, if you want. With the formula above, F2 will always equal A2 when E2 is "yes", even if A2 is not 2. Is that what you want? Or did you intend something like: =if(and(E2="yes", A2=2), 2, "") Thus, F2 is 2 only when E2 is "yes" and A2 is 2. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simple formula
Thank You!!
wrote: marley wrote: in cell A2 I have 2 If i enter a "yes" in E2 I want F2 to equal 2 (same as A2) What if E2 is not "yes"? Learn to always specify the "otherwise" (else) case. For what you have specified thus far, in F2, write: =if(E2="yes", A2, "") The 3rd parameter ("") leaves the cell empty if E2 is not "yes". Fill in something else appropriate, if you want. With the formula above, F2 will always equal A2 when E2 is "yes", even if A2 is not 2. Is that what you want? Or did you intend something like: =if(and(E2="yes", A2=2), 2, "") Thus, F2 is 2 only when E2 is "yes" and A2 is 2. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simple formula
Thank You!!
wrote: marley wrote: in cell A2 I have 2 If i enter a "yes" in E2 I want F2 to equal 2 (same as A2) What if E2 is not "yes"? Learn to always specify the "otherwise" (else) case. For what you have specified thus far, in F2, write: =if(E2="yes", A2, "") The 3rd parameter ("") leaves the cell empty if E2 is not "yes". Fill in something else appropriate, if you want. With the formula above, F2 will always equal A2 when E2 is "yes", even if A2 is not 2. Is that what you want? Or did you intend something like: =if(and(E2="yes", A2=2), 2, "") Thus, F2 is 2 only when E2 is "yes" and A2 is 2. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simple formula
Hi!
I love simple formulas! Enter this in F2: =IF(E2="Yes",A2,"") Biff "marley" wrote in message ups.com... in cell A2 I have 2 If i enter a "yes" in E2 I want F2 to equal 2 (same as A2) I know this is simple, but I can't figure it out. Help. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i know this is simple, but driving me nuts - formula | Excel Worksheet Functions | |||
Simple Excel Formula Help | New Users to Excel | |||
When inserting a simple "Sum" formula all I get is the formula. | Charts and Charting in Excel | |||
Need help with a simple formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions |