cblincoln43
Board Regular
- Joined
- Mar 12, 2002
- Messages
- 206
I am trying to get excell to transfer the amount in 1 cell (referance) into 3 cells, with a FIXED VALUE RANGE as in:
CELL...I3--- =--REFERANCE
CELL...K3--- =--0.1 TO 8.0
CELL...L3--- =--8.1 TO 12.0
CELL...M3--- =--12.0 TO THE BALANCE OF THE REFERANCE, OR;
....I3.....INTO...K3.....L3....M3
...15.0....INTO...8.0...4.O...3.0
....9.5....INTO...8.0...1.5...0.0
....8.0....INTO...8.0...0.0...0.0
....6.1....INTO...6.1...0.0...0.0
"0" CAN BE BLANK
With the folumla i have, i receive the following;
...I3....into.....K3.....L3......M3
...15.0...into....8.0...12.0......3.0
...9.5...into....8.0....1.5.....FALSE
...8.0...INTO....8.0...BLANK....FALSE
...0.0...into....0.0...BLANK....FALSE
This is simple mind math, that ive seen done. But I can't get this computer to do it HELPPPPP ! bob
CELL...I3--- =--REFERANCE
CELL...K3--- =--0.1 TO 8.0
CELL...L3--- =--8.1 TO 12.0
CELL...M3--- =--12.0 TO THE BALANCE OF THE REFERANCE, OR;
....I3.....INTO...K3.....L3....M3
...15.0....INTO...8.0...4.O...3.0
....9.5....INTO...8.0...1.5...0.0
....8.0....INTO...8.0...0.0...0.0
....6.1....INTO...6.1...0.0...0.0
"0" CAN BE BLANK
With the folumla i have, i receive the following;
...I3....into.....K3.....L3......M3
...15.0...into....8.0...12.0......3.0
...9.5...into....8.0....1.5.....FALSE
...8.0...INTO....8.0...BLANK....FALSE
...0.0...into....0.0...BLANK....FALSE
This is simple mind math, that ive seen done. But I can't get this computer to do it HELPPPPP ! bob