VM function

[Csadr]

I received a spreadsheet to work with and there was an IF function used
in some cells such as below:

=IF(+VM!A14<>"",+VM!A14<>," ")

I could not find any explanations for VM function and I am wondering
what it is. Can some help me please?

Thanks,
csadr

 

[Alan]

VM!A14 refers to cell A14 in worksheet VM in that workbook. The syntax !, ie
VM! is what has to be entered if a formula in one worksheet refers to a cell
in another worksheet.

 

[Aladin Akyurek]

VM is the name of a worksheet in the workbook that houses the formula.

The formula appears to be incompletely specified:

=TRIM(VM!A14)<>""

would also suffice.

 

[Gord Dibben]

csadr

VM is not a Function.

VM is the name of a worksheet.

Your formula has references to it.

VM!A14 is cell A14 on worksheet VM

Gord Dibben XL2002

 

[J.E. McGimpsey]

VM!A14

is a reference to Sheet VM, Cell A14.