ExcelBanter - what does the star (*) indicate in an excel spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - what does the star (*) indicate in an excel spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/19741-what-does-star-%2A-indicate-excel-spreadsheet.html)

tim

what does the star (*) indicate in an excel spreadsheet

Jerry W. Lewis

More information is needed to determine the context of your question.
Among other things,
* is used for multiplcation, e.g. =2*3 in a cell will produce 6
* is used as a wild card in searches
* marks data sources from pre 97 versions of Query
* can be used as a text character
....

Jerry

Nadia

Im assuming you're very new to XL and you are referring to a formula, e.g.,
=A1*B1
this indicates multiplication

"tim" wrote:

All times are GMT +1. The time now is 03:53 PM.