+ Reply to Thread
Results 1 to 5 of 5

Can you please tell me what is the meaning of =+A1*B1 vs =A1*B1

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    51

    Question Can you please tell me what is the meaning of =+A1*B1 vs =A1*B1

    Hi..

    Can you please tell what is the meaning of =+A1*B1 vs =A1*B1?

    Thanks in advance
    Last edited by Novice_To_Excel; 03-07-2015 at 01:27 PM. Reason: Got the answer

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,601

    Re: Can you please tell me what is the meaning of =+A1*B1 vs =A1*B1

    Nothing.
    Some users are used to write + in front of formula as a habit of some other programs.

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Can you please tell me what is the meaning of =+A1*B1 vs =A1*B1

    Comes from Lotus I think

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,723

    Re: Can you please tell me what is the meaning of =+A1*B1 vs =A1*B1

    It means the same. When you are typing in a formula then if what you have typed begins with an equals sign or an arithmetic operator, then Excel will recognise it as a formula, rather than as text, so you could type:

    +A1*B1

    and Excel will then display this in the formula bar as:

    =+A1*B1

    Hope this helps.

    Pete

  5. #5
    Registered User
    Join Date
    09-21-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Can you please tell me what is the meaning of =+A1*B1 vs =A1*B1

    Thank you guys... you are awesomely quick...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. #REF! Meaning
    By este994 in forum Excel General
    Replies: 1
    Last Post: 08-18-2011, 10:23 AM
  2. what is the meaning of (--) in a formula
    By jmaterano in forum Excel General
    Replies: 4
    Last Post: 02-05-2011, 01:17 PM
  3. Meaning of E
    By Ganivada in forum Excel General
    Replies: 2
    Last Post: 11-27-2009, 11:09 AM
  4. meaning of #########
    By dick in forum Excel General
    Replies: 2
    Last Post: 01-10-2006, 09:30 AM
  5. [SOLVED] The meaning and uses for ans
    By Pat in forum Excel General
    Replies: 3
    Last Post: 04-04-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1