» Combining Text and Numerically Calculated Results into One Output String
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
We want to calculate the reduced price corresponding to each full price in column A.
The result is to be included in the following output string: "Reduced price is $XX.XX".
Price reductions are calculated as follows:
80% of full price for prices over $80.
90% of full price for all other prices.
Solution:
Use the CONCATENATE, TEXT, and IF functions as shown in the following formula:
= CONCATENATE("Reduced price is", TEXT(IF(A2>80,80%*A2,90%*A2),"$00.00"))
Book Store:
Recommended Books:
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Financial Reporting and Analysis (2nd Edition)
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Business Plans Kit for Dummies (With CD-ROM)
- Special Edition Using Microsoft Word 2002
No comments have been submitted.
