Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highest Values Comparison | Excel Worksheet Functions | |||
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Discussion (Misc queries) | |||
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Worksheet Functions | |||
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Programming | |||
Looking up value that has two comparison values | Excel Discussion (Misc queries) |