I have a cell that if it goes over the number 40 its put amount over into an
other cell--
Thanks Lakebum

Try HELP IF function.
"Lakebum" wrote in message
...
I have a cell that if it goes over the number 40 its put amount over into
an
other cell--
Thanks Lakebum

Perhaps a simple illustration
to complement your reading of Excel's HELP ..

Assuming the numbers are listed in A1 down
Put in B1: =IF(A140,A1,"")
Copy B1 down

Col B will return only numbers from col A which exceed 40,
otherwise it'll return blanks: ""
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Barb Reinhardt" wrote in message
...
Try HELP IF function.
"Lakebum" wrote in message
...
I have a cell that if it goes over the number 40 its put amount over into
an
other cell--
Thanks Lakebum

"Lakebum" wrote:
I have a cell that if it goes over the number 40 its
put amount over into an other cell--

Suppose the first cell is A1. If I understand you
correctly, in the "other cell", you might have the
following formula:

=IF(A1 40, A1, "")

Hi

A formula cannot put a value into another cell. You can have formulae in
other cells to distribute you value to give up to 40 in one cell, and values
above 40 (if they exist) in another cell.
If cell A1 contains your raw data, then you could enter in
B1 =MIN(40,A1) and in
C1 =MAX(0,A1-40)

Regards

Roger Govier


Lakebum wrote:
I have a cell that if it goes over the number 40 its put amount over into an
other cell--
Thanks Lakebum