» 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:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- The Guide to Understanding Financial Statements
- Windows XP All-in-One Desk Reference For Dummies
- Microsoft Windows XP Registry Guide
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
No comments have been submitted.
