+ Reply to Thread
Results 1 to 2 of 2

Correcting formula

  1. #1
    mistral
    Guest

    Correcting formula

    Have problem to round up result, total show 709.99, I need get 710.00
    Formulas from last column(from top to bottom):

    G17 cell - formula is =E17*F17
    G18 cell - =E18*F18

    G29 cell - =SUM(G17:G28)
    G31 cell - =ROUND(IF(G30=0;G29;(1-G30/100)*G29);2) --> this formula
    calculate discount(in G30 cell), cell empty, no data.

    G33 cell - =G29*0.18
    G34 cell - =G31+G33


    thanks



  2. #2
    Niek Otten
    Guest

    Re: Correcting formula

    http://www.mcgimpsey.com/excel/pennyoff.html

    --
    Kind regards,

    Niek Otten
    Microsoft MVP - Excel

    "mistral" <mistral@mistral.net> wrote in message news:%23s44oBUvGHA.1296@TK2MSFTNGP02.phx.gbl...
    | Have problem to round up result, total show 709.99, I need get 710.00
    | Formulas from last column(from top to bottom):
    |
    | G17 cell - formula is =E17*F17
    | G18 cell - =E18*F18
    |
    | G29 cell - =SUM(G17:G28)
    | G31 cell - =ROUND(IF(G30=0;G29;(1-G30/100)*G29);2) --> this formula
    | calculate discount(in G30 cell), cell empty, no data.
    |
    | G33 cell - =G29*0.18
    | G34 cell - =G31+G33
    |
    |
    | thanks
    |
    |



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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