LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I skip blank cells when writing formulas KatB Excel Worksheet Functions 1 July 11th 06 09:53 PM
Copying Formulas In Cells That Are Not Nested grendel Excel Discussion (Misc queries) 1 April 26th 06 03:38 AM
Copying formulas to other cells. Keeping references w/o $ sign. GregP1962 Excel Discussion (Misc queries) 10 April 22nd 06 03:11 AM
Formula to Sum Cells that Hold If Formulas Brad Larsen Excel Worksheet Functions 2 February 21st 06 07:26 PM
pasting or moving formula cells without updating formulas jake Excel Discussion (Misc queries) 2 April 14th 05 01:02 PM


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"