98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Can I apply more than one function to the same cell?
Can I apply more than one function to the same cell?
Resolved · Low Priority · Version 2013
Matthew has attended:
Project Management - Framework & Processes course
Excel Intermediate course
Excel Advanced course
Excel VBA Introduction course
Can I apply more than one function to the same cell?
Dear STL Team,
Scenario: Staff have bough a new phone but if the phone is less than £250 they do not pay for it. If it is over £250 they pay the difference.
I have used an IF function which works as follows. "Price">=250, "Price"-250, "No Charge". This returns no charge for all prices below £250 and gives me the difference for all the others. However, there is a twist. Some cells in the price column do not contain a number so return an error message. I can delete the message leaving the cell blank. My question is how then can i create a formula to insert text into the blank cells which does not affect the IF function?
Many thanks
Matthew
RE: Can I apply more than one function to the same cell?
Hi Matthew,
Thank you for your question. Might I suggest, instead of deleting the text entries from the Price column, to place the IF function inside an IFERROR function. This will return a result saying, for example, "Non numeric data" instead of #VALUE. Below is an example:
=IFERROR(IF(A2>=250,A2-250,"No charge"),"Non numeric data")
This would be the simplest solution as it will still reflect the amount payable or say "No charge".
I hope this helps.
Kind regards
Marius Barnard
STL
Thu 7 Jul 2016: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Importing Numbers in Excel 2010Occasionally, when importing data into Excel you find that the some of the imported values are treated as text. |