ExcelBanter - Using MIN Function on cells containing formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using MIN Function on cells containing formulas (https://www.excelbanter.com/excel-worksheet-functions/107166-using-min-function-cells-containing-formulas.html)

Using MIN Function on cells containing formulas

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.

Using MIN Function on cells containing formulas

Hi Don,

Thanks for your reply. Don't ever try to figure things out end of the
day on Friday. I realized there was a circular reference happening in
the sum and it was messing up the totals. I did know there didn't have
to be the + after the = it was just another fun mistake! :)

Thanks,
Bri

Don Guillett wrote:
Should work. Does one of the cells requested have 0?
BTW
=+B46+B58)
need not have the 1st +. This is NOT lotus
=B46+B58
is all you need

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
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.