+ Reply to Thread
Results 1 to 2 of 2

Very Simple Question About Minus Between Two Values

Hybrid View

  1. #1
    Registered User
    Join Date
    01-28-2016
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS 2014
    Posts
    1

    Unhappy Very Simple Question About Minus Between Two Values

    I was trying to have difference between two values but it is giving an error of value

    like

    Column A B C
    56% 30% =B2-A2 [error=Value]

    Why it's happening?

    Thanks!
    You are WHAT you eat!

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: Very Simple Question About Minus Between Two Values

    try

    =(A1+0)-(B1+0)
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ 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. Replies: 6
    Last Post: 12-20-2015, 03:55 PM
  2. Simple question: Plot column with text vs column with values
    By Morridini in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-11-2014, 12:24 PM
  3. [SOLVED] Hopefully a simple question. Getting Textbox to Total Values from Spreadsheet Column?
    By t0mps in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2014, 11:59 AM
  4. Simple Question using MAC 2011 Version - How to add values in ROWS
    By mcemail in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-29-2014, 03:27 PM
  5. Simple minus formula not working
    By kakhuis in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 08-05-2013, 11:20 AM
  6. Simple Minus
    By hoganc in forum Excel General
    Replies: 2
    Last Post: 02-01-2005, 09:29 AM
  7. Simple Question, 2 Values per point
    By foamcows in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-20-2005, 01:29 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