LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
PSU35
 
Posts: n/a
Default Summing & return highest value

Cell A1 may have a number entered.
Cells A2 thru A13 may have numbers entered.
I want cell A14 to display which ever has the higher value.... A1 or the sum
of cell range A2:A13.

What would be the formula? Please no VBA or macro's
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
annualized return calculation for the purpose of portfolio performance evaluation sharkey Excel Worksheet Functions 2 April 8th 06 09:41 PM
Monthly Stock Return Volatility frank Excel Discussion (Misc queries) 6 February 21st 06 05:18 PM
check if reference exists, then return its value or return 0 doudou Excel Worksheet Functions 1 June 4th 05 09:17 PM
How do create a formula to evalute a # to return 1 of 4 conditions Larry Excel Worksheet Functions 4 May 29th 05 12:58 AM
Using a Vlookup to return values in a data list? rtjeter Excel Worksheet Functions 2 April 26th 05 05:56 AM


All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"