| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula AND OR
Hello
=IF(B29=" $25,000 Annually ", "Stipend", "New Schedule") what I want to do is add to this formula if it says select then blank. or "" Not sure how to do this thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula AND OR
Not sure I get question.
=IF(B29="select", "", IF(B29=" $25,000 Annually ", "Stipend", "New Schedule") ) B29 result select blank 25,000... stipend anything else new sched. Real AND/OR IF(OR(B29=" 25,000 Annually", ISBLANK(B29)), "Stipend", "New schedule") B29 result blank or 25,000... Stipend anything else New Schedule best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Wanna Learn" wrote in message ... Hello =IF(B29=" $25,000 Annually ", "Stipend", "New Schedule") what I want to do is add to this formula if it says select then blank. or "" Not sure how to do this thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula AND OR
THanks Bernard
Let me rephrase I will try to follow your pattern if B29 = $25,000 answer should be "Stipend" ifB29 = the word "select" then "" if B29 equals anything else then "New Schedule" hope this is better to undestand "Bernard Liengme" wrote: Again thanks Not sure I get question. =IF(B29="select", "", IF(B29=" $25,000 Annually ", "Stipend", "New Schedule") ) B29 result select blank 25,000... stipend anything else new sched. Real AND/OR IF(OR(B29=" 25,000 Annually", ISBLANK(B29)), "Stipend", "New schedule") B29 result blank or 25,000... Stipend anything else New Schedule best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Wanna Learn" wrote in message ... Hello =IF(B29=" $25,000 Annually ", "Stipend", "New Schedule") what I want to do is add to this formula if it says select then blank. or "" Not sure how to do this thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula AND OR
=IF(B29=" $25,000 Annually ","Stipend",IF(B29="select","","New Schedule"))
but that's equivalent to the first answer Bernard gave you. Did you try it? -- David Biddulph "Wanna Learn" wrote in message ... THanks Bernard Let me rephrase I will try to follow your pattern if B29 = $25,000 answer should be "Stipend" ifB29 = the word "select" then "" if B29 equals anything else then "New Schedule" hope this is better to undestand "Bernard Liengme" wrote: Again thanks Not sure I get question. =IF(B29="select", "", IF(B29=" $25,000 Annually ", "Stipend", "New Schedule") ) B29 result select blank 25,000... stipend anything else new sched. Real AND/OR IF(OR(B29=" 25,000 Annually", ISBLANK(B29)), "Stipend", "New schedule") B29 result blank or 25,000... Stipend anything else New Schedule best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Wanna Learn" wrote in message ... Hello =IF(B29=" $25,000 Annually ", "Stipend", "New Schedule") what I want to do is add to this formula if it says select then blank. or "" Not sure how to do this thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula AND OR
Hello I got it the end of the formula should be IF(B29="select","",""))
then it works. thanks for your help could not have done it without you guys "David Biddulph" wrote: =IF(B29=" $25,000 Annually ","Stipend",IF(B29="select","","New Schedule")) but that's equivalent to the first answer Bernard gave you. Did you try it? -- David Biddulph "Wanna Learn" wrote in message ... THanks Bernard Let me rephrase I will try to follow your pattern if B29 = $25,000 answer should be "Stipend" ifB29 = the word "select" then "" if B29 equals anything else then "New Schedule" hope this is better to undestand "Bernard Liengme" wrote: Again thanks Not sure I get question. =IF(B29="select", "", IF(B29=" $25,000 Annually ", "Stipend", "New Schedule") ) B29 result select blank 25,000... stipend anything else new sched. Real AND/OR IF(OR(B29=" 25,000 Annually", ISBLANK(B29)), "Stipend", "New schedule") B29 result blank or 25,000... Stipend anything else New Schedule best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Wanna Learn" wrote in message ... Hello =IF(B29=" $25,000 Annually ", "Stipend", "New Schedule") what I want to do is add to this formula if it says select then blank. or "" Not sure how to do this thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula AND OR
If you have IF(B29="select","","")) then you're never going to get the "New
Schedule" that you asked for, but I'm glad that you're happy. -- David Biddulph "Wanna Learn" wrote in message ... Hello I got it the end of the formula should be IF(B29="select","","")) then it works. thanks for your help could not have done it without you guys "David Biddulph" wrote: =IF(B29=" $25,000 Annually ","Stipend",IF(B29="select","","New Schedule")) but that's equivalent to the first answer Bernard gave you. Did you try it? "Wanna Learn" wrote in message ... THanks Bernard Let me rephrase I will try to follow your pattern if B29 = $25,000 answer should be "Stipend" ifB29 = the word "select" then "" if B29 equals anything else then "New Schedule" hope this is better to undestand "Bernard Liengme" wrote: Again thanks Not sure I get question. =IF(B29="select", "", IF(B29=" $25,000 Annually ", "Stipend", "New Schedule") ) B29 result select blank 25,000... stipend anything else new sched. Real AND/OR IF(OR(B29=" 25,000 Annually", ISBLANK(B29)), "Stipend", "New schedule") B29 result blank or 25,000... Stipend anything else New Schedule best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Wanna Learn" wrote in message ... Hello =IF(B29=" $25,000 Annually ", "Stipend", "New Schedule") what I want to do is add to this formula if it says select then blank. or "" Not sure how to do this thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
