excel training - 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