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

1. ## 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

2. ## Re: HELP with an Excel problem please?

see attached worksheet

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

Originally Posted by excellhobo
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

4. ## 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

6. ## 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. ## 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.

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

#### 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