IIf AND Statement In Access | MrExcel Message Board
Most of my tables have lookup tables to calculate values, but I am in the need of an IF/AND statement and do not have the Access knowledge to draft one. In Excel (substituing my field names for Excel cells) it would look like IF(AND(TranType=PX, MarketNAT,Derived Type=PA),1,0) How would I
Actived: Thursday Mar 26, 2020
MrExcel and Other MVPs to Return to Excelapalooza 2019
Use Coupon Code: MRMVP for $100 Off registration. Bill Jelen is the author / co-author of Excel Dynamic Arrays Straight to the Point 2nd Edition. Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how
UserVoice - What is your Idea to Improve Excel? - Excel
I will reply with a link to my 2-page full-color laminated Pivot Table tip card, plus a secret coupon code for 20% off the Power Pivot Premium add-in. Bill Jelen is the author / co-author of MrExcel 2020 - Seeing Excel Clearly. This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's
VBA: alternative to sendkeys - is it possible?
Hello I need to automatically fill forms in my software (not Excel). I don't want to use sendkeys because this method in not reliable. There is a software that changes object values of running applications -->link--that's the method I would like to use. I wrote to the author but didn't answer so I'm asking you: is it possible to use this method in Excels VBA?
Copy of vba Code from Pivot Table Data Crunching
(even with the coupon code I was provided with my copy of the book.) Does anyone know how I can get copies of the vba code in 'Pivot Table Data Crunching, Microsoft Excel 2010'? I would hate to have to retype everything - or even just the code I'm interested in using. Thank you,
two percentage discounts in one cell
Methinks they got it right. This 'double-discounting' practice is common in the U.S., where department stores advertise 40% off sale prices, and then entice you with bonus 20% off coupons. Unfortunately, you don't get a $100.00 sweater for $40.00, but $48.00.