if fuction

[Guest]

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

 

[Barb Reinhardt]

Try HELP IF function.

 

[Max]

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

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

Col B will return only numbers from col A which exceed 40,
otherwise it'll return blanks: ""

--

 

[Guest]

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, "")

 

[Roger Govier]

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