+ Reply to Thread
Results 1 to 2 of 2

Ignoring Negative Values?

  1. #1
    Registered User
    Join Date
    02-25-2007
    Posts
    3

    Question Ignoring Negative Values?

    Hi,

    I would like to edit my spreadsheet so it adds up ticket requirements for my rugby club but am having issues with negative values!

    Basically when an adult purchases a ticket they are also allocated a free child’s ticket, any extra children are additional purchases, and there is also the option of paying for seats on a coach.

    I have put this formula into a cell but it goes wrong when I have a negative value... =(D4-C4)*6+(C4*12)+(E4*5)
    1: (D4) Child tickets - (C4) Adult Tickets * £6
    2: + (C4) Adult tickets * £12
    3: + (E4) Coach seats * £5

    The first part is where the negative values are coming from... the formula is taking away the negative value from the total amount to pay and I can’t figure out how to fix it??

    Any help is most appreciated.

    Thanks

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481
    (D4) Child tickets - (C4) Adult Tickets * £6
    is this where you are finding the number of child tickets??

+ 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