How do i do this?

R

R.P.McMurphy

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
 
R

r.p.mcmurphy

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

:)

steve
 
B

Bob Phillips

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)
 
R

R.P.McMurphy

As Woolsey or something like that. cant remeber what he looked like now.
time i saw it again!

steve
 
Top