View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.newusers
Totti Totti is offline
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