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

On Wed, 20 Apr 2016 15:14:11 +0200, Claus Busch wrote:

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.


Thanks for your fast response :-)

Cheers


Dave R


--
Windows 8.1 on PCSpecialist box