How do I look at 3 cells & add together the highest & lowest value?

**Mr Bean1961** · 09-24-2009, 09:35 AM

Hi,

Could any of you Excel bods please help me find the correct formula to enter in order to calculate the following reasonably simple sum:

3 cells with numbers, say, 1, 3 & 7.

I simply need to get my worksheet to look at all three cells and then calculate the result of adding the biggest and smallest number together. i.e. 8 in the example given.

Thanks.

**arthurbr** · 09-24-2009, 09:36 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**Mr Bean1961** · 09-24-2009, 09:42 AM

Title revised as requested above.

**ChemistB** · 09-24-2009, 09:48 AM

Let's say your values are in A1, A2, A3

Please Login or Register  to view this content.

or if noncongruent like A1, J5, D3

Please Login or Register  to view this content.

Is that what you are looking for?

Note: Depending on your Excel, comma's in the second equation might need to be replaced by semi colons.

**arthurbr** · 09-24-2009, 09:55 AM

Originally Posted by Mr Bean1961

Title revised as requested above.

The idea is to cchange the title of your original post so that it can be searched on in the future. I will do it for you

**NBVC** · 09-24-2009, 09:56 AM

arthurbr...

it seems the OP changed the title on post #3 and not on the original post....

... but the OP has also duplicated the thread....

**Mr Bean1961** · 09-24-2009, 05:45 PM

Sorry about all the confusion and rule breaking. I am in other unrelated forums and the rules are slightly more 'malleable'. I will try to take the time to read yours more thoroughly.

That said, my problem has been resolved by two posters so thank you. I have added to both of their reputations.

Now....how do I show this thread as 'solved'?

**shg** · 09-24-2009, 05:57 PM

how do I show this thread as 'solved'?

Erm -- it's in those forum rules.

**broro183** · 09-24-2009, 06:13 PM

lol, something in your throat, Shg? :-)

The problem's solved now, but here is another possibility for the melting pot...

Please Login or Register  to view this content.

Note, I'm not sure if the Median function is available in 2003 & earlier. Also the same principle that ChemistB suggests for non-contiguous cells can be used on this formula.

hth
Rob