How do i do this?

  • Thread starter Thread starter R.P.McMurphy
  • Start date Start date
Nope, that dosnt work. this is what is working atm.

=SUM(IF(G4:BJ4>$C$4,$C$4,G4:BJ4)*(MOD(COLUMN(G4:BJ4)-6,5)=COLUMN(A1))*$D$4)*0.10638

how do i get it round to the nearest quater?

also, can you explain this formula in normal terms? thats the only way i'm
gonna learn how to do this myself...and then i wont have to pick your
brains! Excel help dosnt seem very useful!

steve
 
I'm a psychie nurse. I could call myself Nurse Ratchet, but that would be
misleading wouldn't it?

:-)

steve
 
But RP was a victim of such nurses. You have to call yourself Nurse Ratched.

Did you know that Philip Roth appeared in that film?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
As Woolsey or something like that. cant remeber what he looked like now.
time i saw it again!

steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vacation accrual formula needed 2
Complete Novice! Require help with "simple" Excel doc 0
Excel 2003 - How to do this 2
dsum query 1
How to do a formula counting the number of hours between 2 times? 2
if statement = if number is between 1
Time Taken Calculation 1
Accrual 1

Back
Top