Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
I'm trying to use the MIN function to retrieve the smallest bid amount in a document (ex =MIN(B60,J60,N60,R60,V60)). The cells I'm retrieving from contain the SUM formula to get the total bid amount (ex =+B46+B58). When I got to InsertFunction and place the MIN function (=MIN(B60,J60,N60,R60,V60)) I can see at the bottom that "Formula result=" is correct ($123,456), but the cell containing the MIN function just reads $0. Any help on this would be soOo appreciated. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I skip blank cells when writing formulas | Excel Worksheet Functions | |||
Copying Formulas In Cells That Are Not Nested | Excel Discussion (Misc queries) | |||
Copying formulas to other cells. Keeping references w/o $ sign. | Excel Discussion (Misc queries) | |||
Formula to Sum Cells that Hold If Formulas | Excel Worksheet Functions | |||
pasting or moving formula cells without updating formulas | Excel Discussion (Misc queries) |