|
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 10:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com