+ Reply to Thread
Results 1 to 2 of 2

Using the following text and formula i'm unable to round up the answer to 2 decimal places

  1. #1
    Registered User
    Join Date
    01-14-2014
    Location
    England
    MS-Off Ver
    Excel 2013
    Posts
    1

    Using the following text and formula i'm unable to round up the answer to 2 decimal places

    Here is my text and formula it is all in one cell

    ="2 Years Parts & 1 Year Labour (Ex VAT) = £"&(I6-I3) &" (Inc VAT) =£"& (I6-I3)*0.2+(I6-I3)

    i need the answer to be to 2 decimal places

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

    Re: Using the following text and formula i'm unable to round up the answer to 2 decimal pl

    You can do it like this:

    ="2 Years Parts & 1 Year Labour (Ex VAT) = £" & TEXT((I6-I3),"0.00") &" (Inc VAT) =£" & TEXT((I6-I3)*0.2+(I6-I3),"0.00")

    Hope this helps.

    Pete

+ 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. Round variable to 4 decimal places
    By achidsey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2014, 02:52 PM
  2. [SOLVED] Round 2 decimal places
    By Ventoux in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2013, 02:17 PM
  3. [SOLVED] Round numbers to decimal places
    By bigband1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-01-2013, 11:34 AM
  4. Round to two decimal places
    By golfnutte in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-08-2007, 05:48 PM
  5. [SOLVED] ROUND DATA TO 2 DECIMAL PLACES
    By roy in sunbury in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-12-2005, 12:06 AM

Tags for this Thread

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