+ 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 365 Win 11 Home 64 Bit
    Posts
    21,484

    Re: HELP with an Excel problem please?

    see attached worksheet
    Attached Files Attached Files
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

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

    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 365 Win 11 Home 64 Bit
    Posts
    21,484

    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 365 Win 11 Home 64 Bit
    Posts
    21,484

    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. [SOLVED] EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN .
    By P.S.Sodha in forum Excel General
    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