LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 51
Default Function or Formula in Excel

to get the lowest amount, i think it would be proper to use the
function MIN, like if you have your amounts concerning FREIGHT, in the
cells B1,C1,D1,E1,
=MIN(B1:E1)
apply MIN to the range of prices and it would give you the smallest

Regards, Totti
 
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
EXCEL FUNCTION OR FORMULA sue Excel Discussion (Misc queries) 13 August 15th 08 04:23 PM
Excel formula / IF function JE Excel Worksheet Functions 6 May 29th 08 12:15 AM
i am in search of Formula / Function in EXCEL-2003 Nimish Shah Excel Discussion (Misc queries) 17 January 24th 08 02:50 PM
excel formula/function woes Domenic Excel Worksheet Functions 0 March 19th 05 10:57 PM
How do I create a multi formula IF function in Excel? Wazza Excel Worksheet Functions 8 November 8th 04 09:25 PM


All times are GMT +1. The time now is 04:11 AM.

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"