+ Reply to Thread
Results 1 to 7 of 7

Excel Problem with worksheet, need to know which function for penny a day doubled problem

  1. #1
    Registered User
    Join Date
    10-18-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    3

    Excel Problem with worksheet, need to know which function for penny a day doubled problem

    so i have a worksheet that basically has the penny a day doubled prob for school. and what i need to do for part of it is take out 16 days(of 64 days) in the form of 8 weekends and recalculate the results, how do i do this? details will help as im retarded, please dont just say such and such function
    Last edited by excellhobo; 10-18-2013 at 03:53 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,532

    Re: HELP with an Excel problem please?

    see attached worksheet
    Attached Files Attached Files

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,503

    Re: Excel Problem with worksheet, need to know which function for penny a day doubled prob

    Quote Originally Posted by excellhobo View Post
    so i have a worksheet that basically has the penny a day doubled prob for school. and what i need to do for part of it is take out 16 days(of 64 days) in the form of 8 weekends and recalculate the results, how do i do this? details will help as im retarded, please dont just say such and such function
    I think this is the same problem I was tasked with many moons ago when I was at school, but then it was referred to as something to do with rice and a chessboard.

    Perhaps if you post your current workbook and explain a little more about what you need we'll be able to help quicker.

    EDIT: Nevermind, Alan beat me to it with a nice simple answer
    Last edited by BadlySpelledBuoy; 10-18-2013 at 04:14 PM.

  4. #4
    Registered User
    Join Date
    10-18-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel Problem with worksheet, need to know which function for penny a day doubled prob

    hey man, i see you used the today and if functions how does that work? i gotta do 1 worksheet with the weekends missing 8 weekends, and 1 with 1 saturday or whatever missing so 8 saturdays, im writing this from home but i dont have excel so have to wait till tomorrow for school

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,532

    Re: Excel Problem with worksheet, need to know which function for penny a day doubled prob


  6. #6
    Registered User
    Join Date
    10-18-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel Problem with worksheet, need to know which function for penny a day doubled prob

    thanks, i cant edit my worksheets here but ill play with these tomorrow, i get the today function but the if function is wierd...but ty

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,532

    Re: Excel Problem with worksheet, need to know which function for penny a day doubled prob

    If function is a simple statement testing for a condition (first argument), answer if condition is true (second argument), then last argument is answer if condition is false.

+ 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. Replies: 1
    Last Post: 07-15-2013, 05:25 AM
  2. How to properly order information in excel? Statistics + Excel type problem
    By beisbol16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2009, 06:48 PM
  3. Excel problem (not spreadsheet problem)
    By c991257 in forum Excel General
    Replies: 0
    Last Post: 05-30-2007, 11:18 AM
  4. Started out as an Access problem. Now an Excel problem
    By RobertM in forum Excel General
    Replies: 2
    Last Post: 04-26-2006, 02:35 PM
  5. Replies: 0
    Last Post: 04-02-2005, 09:06 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