| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Greater Than formula
You can do this with the MIN function. In cell B1, enter
=MIN(A1,8) -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "ginasucasa" wrote in message ... I'm in need of the following: a1=9 Formula: If a1 is greater than 8, I need b1 to show 8 only. If it is less than 8, I need it to show the amount that is less than 8. So b1 on this should show 8. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Greater than but less than formula | Excel Worksheet Functions | |||
| Greater than Less than formula | Excel Discussion (Misc queries) | |||
| Greater than formula! | Excel Worksheet Functions | |||
| formula for Greater of C or D X E | Excel Discussion (Misc queries) | |||
| Less than, Greater than Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
