#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lakebum
 
Posts: n/a
Default if fuction

I have a cell that if it goes over the number 40 its put amount over into an
other cell--
Thanks Lakebum
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt
 
Posts: n/a
Default if fuction

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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default if fuction

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





  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default if fuction

"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, "")
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default if fuction

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to use sumbycolor fuction? Ghauri Excel Worksheet Functions 2 November 29th 05 10:00 PM
concatenate fuction NITESH G Excel Discussion (Misc queries) 2 November 7th 05 02:24 PM
Insert Fuction cfraley Excel Worksheet Functions 3 May 11th 05 08:36 PM
IF fuction and format ... MJK700i Excel Worksheet Functions 3 April 24th 05 11:57 AM
Page Number Fuction ChrisA Excel Discussion (Misc queries) 1 February 17th 05 09:58 PM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"