EXCEL 2007

" "

1. This can mean that text is being inserted in the formula.

2. In this example:-

=IF(AND(C2="East",D2<20),D2*100%,"Not Applicable")

The 2 words in inverted commas are text.

"East" means if the formula finds that text (East) in cell C2.

"Not Applicable" means that Not Applicable will be placed into a cell if the
2 conditions in the formula are found to be false.

If my comments have helped please hit Yes.



"Jane" wrote:

When working in excel and doing my labs, I am often told to use " " in my
formulas but I don't know what " " stand for and the ! is also used, can
someone explain to me what " " and ! mean?