Thread
:
Formula
View Single Post
#
8
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Formula
Still nothing's come through.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Sandy Mann" wrote in message
...
Did you see the worksheet I sent you?
No. Did you click on the Reply button? If you did then it would have
gone to mailinator.com which is a spam trap that I do not check. Please
resent it to:
sandymann2 at_sign tiscali.co.uk
making it into a real address .
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"chickieram" wrote in message
...
Did you see the worksheet I sent you?
"Sandy Mann" wrote:
Still not too much detail but assuming that:
1: Cell C1 holds 49
2: Cell D1 holds 100
3: Cell C40 has the total hours worked that month
4: Cell E40 had the numnber of nights
Then try:
=1000+MAX(C40-144,0)*B1+MIN(E40,4)*D1
However, it would be better to put the 1000, 144 & 4 in other cells and
then
refer to that cell so that when something changes you only have to
change
that one cell and all formulas will use the new value.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"chickieram" wrote in message
...
Time and work hours are recorded in Excel and totalled at the end of
the
month.
"Sandy Mann" wrote:
How is the time/work hours recorded?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"chickieram" wrote in message
...
Employee A is paid a base monthly salary of $1,000. She will
receive a
bonus
of $100/night over four nights a month. She will receive another
bonus
of
$49/hour for every hour over 144 hours.
Column D is the $100/night and Column B is the $49/hour.
I am new at this.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann