Re: nested if function
- From: "Biff" <biffinpitt@xxxxxxxxxxx>
- Date: Tue, 13 Jun 2006 14:32:51 -0400
Ok, good deal! Thanks for the feedback!
Biff
"Robb27" <Robb27@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:87B0FFCA-57A8-4742-AF18-358FD8E9B5E6@xxxxxxxxxxxxxxxx
Thank you Biff. The light bulb came on after I worked with your formula
for
awhile. I can see how it works now.
I was right, I was making it more complicated than necessary.
Rob
"Biff" wrote:
"Robb27" <Robb27@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3F9142F9-B11B-4BEE-BCAC-29397BB84AB2@xxxxxxxxxxxxxxxx
Biff,
Thanks for the assistance. But, it's a bit complicated for me. <insert
sheepish grin here> I'm probably over-complicating it. An employee
earns
6.16
hours of PTO every 2 weeks, so. can the formula maybe just add that
number
to
the previous 2 weeks amount AND subtract 8 hours when they put PTO in
the
cell?
Rob
Well, now I'm not following you. Either of those formulas does exactly
what
you asked for.
add that number [6.16] to the previous 2 weeks
But how did you calculate the total for the previous 2 weeks?
Biff
.
- References:
- Re: nested if function
- From: Biff
- Re: nested if function
- From: Biff
- Re: nested if function
- Prev by Date: Re: comparing ranges/arrays
- Next by Date: Re: How to smart count a table with words in it!
- Previous by thread: Re: nested if function
- Next by thread: Re: Title in one cell covering space of 3 cells underneath
- Index(es):
Relevant Pages
|
