VM function

  • Thread starter Thread starter Csadr
  • Start date Start date
C

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
 
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.
 
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.
 
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
 
Back
Top