Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
I am looking to add an if statement where if I use one value, it will produce
the information from one cell, and if I enter a different value it would take info from a second cell. Example: A1 = Value 1, A2 = Value 2, A3 is the if statement, and A4 is the cell with the variable. For the IF statement in the A3 cell, it would be based on the following information. If A4 has the word "yes", it would pull info from A1. If A4 has the value "No", it would pull info from A2. How would I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
Maybe
=IF(A4="Yes",A1,IF(A4="No",A2,"Unspecified")) Mike "JM" wrote: I am looking to add an if statement where if I use one value, it will produce the information from one cell, and if I enter a different value it would take info from a second cell. Example: A1 = Value 1, A2 = Value 2, A3 is the if statement, and A4 is the cell with the variable. For the IF statement in the A3 cell, it would be based on the following information. If A4 has the word "yes", it would pull info from A1. If A4 has the value "No", it would pull info from A2. How would I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
Hi Mike,
This works perfectly, I didn't include the undefined part which threw me off. Can I extend this if statement by asking if Y or yes, would provide a1, if No, or N would provide a2. "Mike H" wrote: Maybe =IF(A4="Yes",A1,IF(A4="No",A2,"Unspecified")) Mike "JM" wrote: I am looking to add an if statement where if I use one value, it will produce the information from one cell, and if I enter a different value it would take info from a second cell. Example: A1 = Value 1, A2 = Value 2, A3 is the if statement, and A4 is the cell with the variable. For the IF statement in the A3 cell, it would be based on the following information. If A4 has the word "yes", it would pull info from A1. If A4 has the value "No", it would pull info from A2. How would I do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
Yes you can do that like this
=IF(LEFT(A4,1)="Y",A1,IF(LEFT(A4,1)="N",A2,"")) Mike "JM" wrote: Hi Mike, This works perfectly, I didn't include the undefined part which threw me off. Can I extend this if statement by asking if Y or yes, would provide a1, if No, or N would provide a2. "Mike H" wrote: Maybe =IF(A4="Yes",A1,IF(A4="No",A2,"Unspecified")) Mike "JM" wrote: I am looking to add an if statement where if I use one value, it will produce the information from one cell, and if I enter a different value it would take info from a second cell. Example: A1 = Value 1, A2 = Value 2, A3 is the if statement, and A4 is the cell with the variable. For the IF statement in the A3 cell, it would be based on the following information. If A4 has the word "yes", it would pull info from A1. If A4 has the value "No", it would pull info from A2. How would I do this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
works great. Thank you Mike
"Mike H" wrote: Yes you can do that like this =IF(LEFT(A4,1)="Y",A1,IF(LEFT(A4,1)="N",A2,"")) Mike "JM" wrote: Hi Mike, This works perfectly, I didn't include the undefined part which threw me off. Can I extend this if statement by asking if Y or yes, would provide a1, if No, or N would provide a2. "Mike H" wrote: Maybe =IF(A4="Yes",A1,IF(A4="No",A2,"Unspecified")) Mike "JM" wrote: I am looking to add an if statement where if I use one value, it will produce the information from one cell, and if I enter a different value it would take info from a second cell. Example: A1 = Value 1, A2 = Value 2, A3 is the if statement, and A4 is the cell with the variable. For the IF statement in the A3 cell, it would be based on the following information. If A4 has the word "yes", it would pull info from A1. If A4 has the value "No", it would pull info from A2. How would I do this? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
One more question if someone can help. Based on below. Looking to see if
I can change this statement. If a4 = "yes", or "please do", then return a1. if a4 = "no" or "maybe not", then return a2. =IF(A4="Yes",A1,IF(A4="No",A2,"Unspecified")) "JM" wrote: works great. Thank you Mike "Mike H" wrote: Yes you can do that like this =IF(LEFT(A4,1)="Y",A1,IF(LEFT(A4,1)="N",A2,"")) Mike "JM" wrote: Hi Mike, This works perfectly, I didn't include the undefined part which threw me off. Can I extend this if statement by asking if Y or yes, would provide a1, if No, or N would provide a2. "Mike H" wrote: Maybe =IF(A4="Yes",A1,IF(A4="No",A2,"Unspecified")) Mike "JM" wrote: I am looking to add an if statement where if I use one value, it will produce the information from one cell, and if I enter a different value it would take info from a second cell. Example: A1 = Value 1, A2 = Value 2, A3 is the if statement, and A4 is the cell with the variable. For the IF statement in the A3 cell, it would be based on the following information. If A4 has the word "yes", it would pull info from A1. If A4 has the value "No", it would pull info from A2. How would I do this? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
Look up the function OR() in Excel help.
-- David Biddulph "JM" wrote in message ... One more question if someone can help. Based on below. Looking to see if I can change this statement. If a4 = "yes", or "please do", then return a1. if a4 = "no" or "maybe not", then return a2. =IF(A4="Yes",A1,IF(A4="No",A2,"Unspecified")) "JM" wrote: works great. Thank you Mike "Mike H" wrote: Yes you can do that like this =IF(LEFT(A4,1)="Y",A1,IF(LEFT(A4,1)="N",A2,"")) Mike "JM" wrote: Hi Mike, This works perfectly, I didn't include the undefined part which threw me off. Can I extend this if statement by asking if Y or yes, would provide a1, if No, or N would provide a2. "Mike H" wrote: Maybe =IF(A4="Yes",A1,IF(A4="No",A2,"Unspecified")) Mike "JM" wrote: I am looking to add an if statement where if I use one value, it will produce the information from one cell, and if I enter a different value it would take info from a second cell. Example: A1 = Value 1, A2 = Value 2, A3 is the if statement, and A4 is the cell with the variable. For the IF statement in the A3 cell, it would be based on the following information. If A4 has the word "yes", it would pull info from A1. If A4 has the value "No", it would pull info from A2. How would I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |