Excel 2010 Formulas.pdf

(21883 KB) Pobierz
458456621 UNPDF
Excel 2010
®
Formulas
John Walkenbach
BONUS CD-ROM!
Includes all Excel workbook files used in the book,
plus the complete book in a searchable PDF file
Microsoft ®
Microsoft ®
458456621.051.png 458456621.060.png 458456621.061.png 458456621.062.png 458456621.001.png 458456621.002.png 458456621.003.png 458456621.004.png 458456621.005.png 458456621.006.png 458456621.007.png 458456621.008.png 458456621.009.png 458456621.010.png 458456621.011.png 458456621.012.png 458456621.013.png 458456621.014.png 458456621.015.png 458456621.016.png 458456621.017.png 458456621.018.png 458456621.019.png 458456621.020.png 458456621.021.png 458456621.022.png 458456621.023.png
458456621.024.png 458456621.025.png 458456621.026.png 458456621.027.png 458456621.028.png 458456621.029.png 458456621.030.png 458456621.031.png
Excel® 2010 Formulas
by John Walkenbach
458456621.032.png 458456621.033.png 458456621.034.png 458456621.035.png 458456621.036.png 458456621.037.png 458456621.038.png 458456621.039.png 458456621.040.png
Excel® 2010 Formulas
Published by
Wiley Publishing, Inc.
111 River Street
Hoboken, NJ 07030-5774
www.wiley.com
Copyright © 2010 by Wiley Publishing, Inc., Indianapolis, Indiana
Published by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any
means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections
107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or
authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood
Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be
addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-
6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions .
Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of
Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, and
related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates in the
United States and other countries, and may not be used without written permission. Excel is a registered trademark
of Microsoft Corporation in the United States and/or other countries. All other trademarks are the property of their
respective owners. Wiley Publishing, Inc., is not associated with any product or vendor mentioned in this book.
LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REPRESENTATIONS
OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS WORK AND
SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT LIMITATION WARRANTIES OF FITNESS FOR A
PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES OR PROMOTIONAL MATERI-
ALS. THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS
WORK IS SOLD WITH THE UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL,
ACCOUNTING, OR OTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES
OF A COMPETENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE AUTHOR
SHALL BE LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION OR WEBSITE IS
REFERRED TO IN THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FURTHER INFORMATION DOES
NOT MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE ORGANIZATION OR WEBSITE
MAY PROVIDE OR RECOMMENDATIONS IT MAY MAKE. FURTHER, READERS SHOULD BE AWARE THAT INTERNET
WEBSITES LISTED IN THIS WORK MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRIT-
TEN AND WHEN IT IS READ. FULFILLMENT OF EACH COUPON OFFER IS THE SOLE RESPONSIBILITY OF THE OFFEROR.
For general information on our other products and services, please contact our Customer Care Department within
the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.
For technical support, please visit www.wiley.com/techsupport .
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be
available in electronic books.
Library of Congress Control Number: 2010925706
ISBN: 978-0-470-47536-2
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
458456621.041.png 458456621.042.png 458456621.043.png 458456621.044.png 458456621.045.png 458456621.046.png 458456621.047.png 458456621.048.png 458456621.049.png 458456621.050.png
About the Author
John Walkenbach is a leading authority on spreadsheet software, and principal of J-Walk and
Associates Inc., a one-person consulting firm based in southern Arizona. John has received a
Microsoft MVP award every year since 2000. He’s the author of more than 50 spreadsheet books,
and has written more than 300 articles and reviews for a variety of publications, including PC
World , InfoWorld , PC Magazine , Windows , and PC/Computing . John also maintains a popular Web
site ( The Spreadsheet Page , http://spreadsheetpage.com ), and is the developer of several
Excel utilities, including the Power Utility Pak, an award-winning add-in for Excel. John graduated
from the University of Missouri, and earned a Masters and PhD from the University of Montana.
458456621.052.png 458456621.053.png 458456621.054.png 458456621.055.png 458456621.056.png 458456621.057.png 458456621.058.png 458456621.059.png
Zgłoś jeśli naruszono regulamin