View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Set value from comparison of other cell values?

Hi DAvid,

Am 20 Apr 2016 12:39:29 GMT schrieb David:

What I want to say is something like "Set C3 to the lowest of B1, B2 and
B3"
[Basically making a decision based on a range of values.]


try:

=MIN(B1:B3)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional