| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I compare values of two cells and display the lowest.
I would like Excel to compare the values in two cells and display the value
that is lowest of the two. Is there a formula to do that? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I compare values of two cells and display the lowest.
Hi Sherri,
=MIN(A1,B1) HTH -- AP "sherri" a écrit dans le message de news: ... I would like Excel to compare the values in two cells and display the value that is lowest of the two. Is there a formula to do that? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I compare values of two cells and display the lowest.
Thank you! I knew it must be easy to do, but I just couldn't find it in
Help. Thanks again! "Ardus Petus" wrote: Hi Sherri, =MIN(A1,B1) HTH -- AP "sherri" a écrit dans le message de news: ... I would like Excel to compare the values in two cells and display the value that is lowest of the two. Is there a formula to do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display formula instead of its values in some cells | Excel Worksheet Functions | |||
| Display text depending on values of 3 different cells? | Excel Worksheet Functions | |||
| Chart to display only bars for values that are > 3 & blank cells | Excel Worksheet Functions | |||
| How to display the "values" included in a formula vs. the cells? | Excel Worksheet Functions | |||
| Format cells to display truncated values? | Excel Discussion (Misc queries) | |||
Linear Mode
