98.7% 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 » excel training - Conditional Formulas
excel training - Conditional Formulas
Resolved · Low Priority · Version Standard
RE: Conditional Formulas
Hi Angela
Thank you for your question; apologies for the delay in response.
The answer is yes, you can enter any function manually into a spreadsheet - you just need to be careful that you enter all the parts of the function in correctly (brackets, commas etc). For example, with the IF function you would need to type
=if(logical test here,value if true here, value if false here)
Notice that there are no spaces between any of the function parts, and that a comma follows the first and second part of the function.
It is important to be careful not to type numbers into the function with commas (e.g. 1,000) as this will confuse Excel as the only place it is expecting to see commas is between the function parts.
Also if you want Excel to display text for the value if true or value if false parts of the function, any text needs to be entered in double quotation marks (e.g. "text here").
I hope this helps.
Amanda
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:Freeze Rows and Columns to keep lables displayedYou can freeze rows and columns in your worksheet so they don't move. |