cblincoln43
Board Regular
- Joined
- Mar 12, 2002
- Messages
- 206
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
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