+ Reply to Thread
Results 1 to 4 of 4

Format is different using same formula?

  1. #1
    Registered User
    Join Date
    12-05-2013
    Location
    Nashville
    MS-Off Ver
    Excel 2010
    Posts
    32

    Format is different using same formula?

    I am using the formula =IFERROR((D10*0.5)+(E10*0.5),"") but in some field it gives me a percentage that rounds and others is giveing me a 4 digit percentage and I can't figure out why. Please assist.

    See attachment.
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Format is different using same formula?

    You need to change all entries in column E to %.
    Let say E35 is integer.
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Registered User
    Join Date
    12-05-2013
    Location
    Nashville
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Format is different using same formula?

    Thanks, I have checked and they are all a %

    It must be something else.

  4. #4
    Registered User
    Join Date
    12-05-2013
    Location
    Nashville
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Format is different using same formula?

    Quote Originally Posted by RobertMika View Post
    You need to change all entries in column E to %.
    Let say E35 is integer.
    It worked, I just had to retype the number to get it to change.

+ 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. [SOLVED] Format painting formula to adjacent cell, and want the result to be in the original format
    By SF1eagles in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-03-2014, 10:49 AM
  2. [SOLVED] Require vba or formula for convert general format data in date format
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-10-2013, 03:53 AM
  3. [SOLVED] Formula for Changing date format 3-12-13 to format d-mm-yy.
    By UNAB in forum Excel General
    Replies: 2
    Last Post: 04-08-2013, 03:52 PM
  4. [SOLVED] Formula/format base don another conditional format
    By ketteringjack in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-12-2012, 07:35 AM
  5. Replies: 2
    Last Post: 10-02-2010, 04:41 AM

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