looking for excel formula.

[cblincoln43]

Im using microsoft office 97, excell and have ran into a simple mind math problem, that has giving me a mind melt down looking for the formula to get excel to do the same thing.
Im trying to get one cell to break down into three cells with a FIXED VALUE RANGE.
AS in:
A1= 15.0 INTO,
C1= 0.1 THROUGH 8.0
D1= 8.1 " 12.0
E1=12.1 " THE BALANCE OF A1.
EXAMPLES:
A1 = 15.0, A1 = 9.5, A1 = 7.5

C1 = 8.0, C1 = 8.0, C1 = 0.0 (OR BLANK)
D1 = 4.0, D1 = 1.5, D1 = 0.0
E1 = 3.0, E1 = 0.0, E1 = 0.0

I need a formula that will make this work for me or a 5lb slug hammer emailed to me for some computer violence. I and my computer will be greatfull for any help. Bob,
This message was edited by cblincoln43 on 2002-03-13 09:05
This message was edited by cblincoln43 on 2002-03-13 09:09
This message was edited by cblincoln43 on 2002-03-13 09:11

 

[neo]

It is a brain teaser, but try this:

in B1 use this formula:

=if(A1="","",if(A1>8,8,A1))

in C1 use this formula:

=if(A1="","",if(A1>12,12,A1-8))

and last, in D1 use this formula:

=if(A1="","",if(A1>12,A1-12,0))

Was this close? I haven't tried it...<marquee><font color=darkgreen><marquee behavior="alternate">neo</marquee>
This message was edited by neo on 2002-03-13 09:12

 

[cblincoln43]

THANK YOU FOR THE WELCOME & THE SHOT TO TRY WILL HAVE TO TRY IT TOMORROW, WILL POST IF IT WORKS. I NEVER DREAMED I WOULD RECIEVE A RESPONCE BEFORE I EVEN FINISHED EDITING. THANK YOU. Bob.