Re: Use of * in formula

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It seems to add a * when it feels the formula is badly formed. so as to make
it able to be evaluated. Most times I get it is when I miss a comma.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"JeffreyBee" <JeffreyBee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:20478C60-E297-4AEA-8E9F-995D9B5BA8F2@xxxxxxxxxxxxxxxx
Excel 2003

Hello,

I have noticed that sometimes Excel tries to add a * to a formula I try to
create that uses nested functions. Can someone explain what the purpose
of
the * is as it relates to functions? I understand its role in multiplying
2
numbers. Just not sure how it is used with functions.

Thank you.


.

Relevant Pages

  • Re: Named Range question
    ... Soldier qualify with primary weapon, pas the APFT, meet height/weight ... My problem is there are more than 7 nested functions ... This worked great for the first cell but it did not work for ... I have it working in Excel 2007 because I can nest more ...
    (microsoft.public.excel.misc)
  • Re: Extracting number of hours as decimal...
    ... Please explain what multiplying it does to the value - Im a little ... See http://www.cpearson.com/excel/datetime.htm for much more about dates and times in Excel. ... Chip Pearson ... Dan Walters ...
    (microsoft.public.excel.misc)
  • Re: Adding Hours in Excel
    ... > In column A employees would enter a start time, ... Just insure that Excel thinks the values you entered are valid times. ... just subtract them and multiply the difference by 24. ... creates a result in fractions of a day, so multiplying by 24 results in ...
    (microsoft.public.mac.office.excel)
  • Re: Contacts & Categories
    ... As far as exporting to Excel, if the only purpose is what you stated, ... the same folder. ...
    (microsoft.public.outlook.contacts)
  • Re: Calculating payroll cost
    ... multiplying by 24 gives you the number of hours. ... Excel Product Group, 1998 - 2009 ... Excel sees the calculated time difference as a decimal instead of a real ... so the total payroll cost is incorrect. ...
    (microsoft.public.excel.worksheet.functions)