Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel training - conditional formulas

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Conditional Formulas

excel training - Conditional Formulas

ResolvedVersion Standard

Angela has attended:
Excel Intermediate course

Conditional Formulas

can I enter these manually

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

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.