Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Which is correct?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Me and my mate Terry have been doing an Excel project,to get the total cost 44.00 and 10.00 must be added and then multiplied by 1.25% to add a charge for use of a credit card.
    The answer I get in my formula is 54.68
    Terrys answer comes to 60.75.
    Which is correct.
    Charlie

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    G'day,

    I can see your formula based on your desc.

    Your formula: =54 + (44+10)*(1.25%) = 54.68

    I'm still not clear how your friend Terry is calculating it.

    Adam

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Terry is using this formula =IF(D10="Credit card",SUM(F6+F8)*0.125,0)

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm not sure what you mean by multiplied by 1.25%. I think what you mean to say, is add on an extra 1.25% to get the final cost.
    In which case, Terry is right.

    (44+10)*1.125 = 60.75

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hold up

    (44+10)*1.125 = 60.75

    +1.25% would be (44+10)*1.0125 = 54.68

    (44+10)*1.125 would be 12.5%

    good catch - didn't think of that

    Adam

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Im still confused HeHe.
    Im using this formula
    =IF(I22="N/A","Ferry Unavailable",(I21+I22)*(1+I23))

    [ This Message was edited by: Charlie on 2002-05-01 07:48 ]

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well spotted!

    Charlie - you're spot on.
    Your mate Terry and I have both just overcharged to the tune of 11.25%!

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I was calling the extra TAT
    Terrys added tax.

    Thanx
    Charlie

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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