Set value from comparison of other cell values?
 

I've just hit a minor problem with Excel - or should I say with my
understanding.

I'm trying to set up a spread sheet to calculate tax rules which are
fairly complex.

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.]

My first tentative investigations haven't shown any obvious syntax.

It looks as though it should be easy; is it?

Cheers

Dave R

--
Windows 8.1 on PCSpecialist box

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

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