Glad it does what you want.
Regards, Dave S
----- Original Message -----Sent: Friday, August 28, 2015 9:04 AMSubject: Re: [ExcelVBA] Multiple IF Statements in Excel 2007
Thanks Dave S. The formula you gave was quite short but correct and it works perfectly!! My formula was very long and incorrect on some point. I kept revising and revising until it became too long. You can see I was struggling as I am still newbie. I'm still understanding how your short formula works.
I plan to translate (or code) this formula into VBA so people won't see the formula or mess with it.
Thank you so much for the big help and for others who responded. My boss will think I am "genius". <lol>
__._,_.___
Posted by: "David Smart" <smartware.consulting@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
.
__,_._,___
Tidak ada komentar:
Posting Komentar