Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #108779 > unrolled thread
| Started by | David <wibble@btintenet.com> |
|---|---|
| First post | 2016-04-20 12:39 +0000 |
| Last post | 2016-04-20 14:00 +0000 |
| Articles | 3 — 2 participants |
Back to article view | Back to microsoft.public.excel.programming
Set value from comparison of other cell values? David <wibble@btintenet.com> - 2016-04-20 12:39 +0000
Re: Set value from comparison of other cell values? Claus Busch <claus_busch@t-online.de> - 2016-04-20 15:14 +0200
Re: Set value from comparison of other cell values? David <wibble@btintenet.com> - 2016-04-20 14:00 +0000
| From | David <wibble@btintenet.com> |
|---|---|
| Date | 2016-04-20 12:39 +0000 |
| Subject | Set value from comparison of other cell values? |
| Message-ID | <dnpbk1F19vfU23@mid.individual.net> |
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
[toc] | [next] | [standalone]
| From | Claus Busch <claus_busch@t-online.de> |
|---|---|
| Date | 2016-04-20 15:14 +0200 |
| Message-ID | <nf7v4r$mqr$1@dont-email.me> |
| In reply to | #108779 |
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
[toc] | [prev] | [next] | [standalone]
| From | David <wibble@btintenet.com> |
|---|---|
| Date | 2016-04-20 14:00 +0000 |
| Message-ID | <dnpgb5F19vfU24@mid.individual.net> |
| In reply to | #108780 |
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
[toc] | [prev] | [standalone]
Back to top | Article view | microsoft.public.excel.programming
csiph-web