| Home |
| Search |
| Today's Posts |
|
#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. |
| 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) | |||
Threaded Mode
