if fuction

L

Lakebum

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

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: ""
 
J

joeu2004

Lakebum said:
I have a cell that if it goes over the number 40 its
put amount over into an other cell--
Click to expand...

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

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
 
Top