looking for cell to cells formula.

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
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Hi

Not too sure I have understood you here, but... Let's say you have a value in cell A1 and you wnat that same value is B1,C1 and D1. There are 2 simple ways.

1 In cell B1 put =$A1 and copy accross to D1

2 Select cells B1:D1 type =A1 in the formula bar, then enter with Ctrl+Shift+Enter

Either method can then be copied down. Personally I would opt for method 1 as method 2 creates an array as is less flexible.
 
Upvote 0
On 2002-03-16 11:29, cblincoln43 wrote:
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

Bob,

In K3 enter:

=(I3>=8)*8+(I3<8)*I3

In L3 enter:

=(I3-K3>=4)*4+(I3-K3<4)*(I3-K3)

In M3 enter:

=I3-(K3+L3)

Select K3:M3 and copy down as far as needed.

Caveat. The formulas expect that there are no negative values in I.

Aladin
 
Upvote 0
Hi. Aladin,
Thought you would like to know that this inexperienced computer wiz(LOL) is so very gratefull. You have saved the life of my computer,as there was a 5 lb hammer easying it's way out of the garage this way. Ive worked over the last month on this and you seem to have done it sooooo easyly.
THANK YOU FOR SHARING WITH ME. I AM GRATEFULL
BOB.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top