| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula with minimum & maximum values
I am trying to create a formula that will multiple two cells (ex: A8*A9) but
I want to make sure the final value is greater than or equal to zero and less than or equal to 400. How would I do this? I appreciate your help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula with minimum & maximum values
Hi. One way...
=MIN(MAX(A8*A9,0),400) -- HTH :) Dana DeLouis Windows XP & Excel 2007 "readystate" wrote in message ... I am trying to create a formula that will multiple two cells (ex: A8*A9) but I want to make sure the final value is greater than or equal to zero and less than or equal to 400. How would I do this? I appreciate your help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula with minimum & maximum values
Thanks to all for your help. I have saved all of the formulas provided as I
am sure they will all be useful. "Dana DeLouis" wrote: Hi. One way... =MIN(MAX(A8*A9,0),400) -- HTH :) Dana DeLouis Windows XP & Excel 2007 "readystate" wrote in message ... I am trying to create a formula that will multiple two cells (ex: A8*A9) but I want to make sure the final value is greater than or equal to zero and less than or equal to 400. How would I do this? I appreciate your help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula with minimum & maximum values
Maybe this:
=IF(AND(A8*A9=0,A8*A9<=400),A8*A9,"") Biff "readystate" wrote in message ... I am trying to create a formula that will multiple two cells (ex: A8*A9) but I want to make sure the final value is greater than or equal to zero and less than or equal to 400. How would I do this? I appreciate your help. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula with minimum & maximum values
=if(or(A8*A9<0,A8*A9400),"Not in range 0-400",A8*A9)
-- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "readystate" wrote: I am trying to create a formula that will multiple two cells (ex: A8*A9) but I want to make sure the final value is greater than or equal to zero and less than or equal to 400. How would I do this? I appreciate your help. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula with minimum & maximum values
Not sure if my post went through, so I'll try once more -
What do you want the cell to display if it is outside of 0-400? Assuming you would want 0 or 400 to be displayed when the product is outside that range, another suggestion: =MEDIAN(A8*A9,0,400) "readystate" wrote: I am trying to create a formula that will multiple two cells (ex: A8*A9) but I want to make sure the final value is greater than or equal to zero and less than or equal to 400. How would I do this? I appreciate your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maximum/minimum value in formula | Excel Discussion (Misc queries) | |||
| Spinners - minimum and maximum | Excel Discussion (Misc queries) | |||
| Maximum & Minimum values in a coulmn | Excel Discussion (Misc queries) | |||
| Maximum and minimum cell value | Excel Discussion (Misc queries) | |||
| pivottable formula : maximum one field - minimum of another one | Excel Discussion (Misc queries) | |||
Hybrid Mode
