Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emily
 
Posts: n/a
Default Excel Formula - to calculate highest number from a set of numbers

I have a list of about 14 numbers in each row, and I need a formula that
calculates the highest number out of a specified set eg. =max(c2, e2, g2,
j2). The problem is that some lines require two cells to have this formula
and when I do that it creates a circular reference. How can I fix this?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Excel Formula - to calculate highest number from a set of numbers

"Emily" wrote:
I have a list of about 14 numbers in each row, and I need a formula that
calculates the highest number out of a specified set eg. =max(c2, e2, g2,
j2). The problem is that some lines require two cells to have this formula
and when I do that it creates a circular reference. How can I fix this?


Not very sure .. but are you having problems because of merged cells ?
Try removing the merged cells, then re-enter the formula ..
(It's best to avoid using merged cells)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply
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
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
Excel formula to calculate % gain when adding cash equity to accou Anita Excel Worksheet Functions 0 April 29th 06 04:19 PM
Excel Formula - Add column of numbers but ignore negative numbers view for Distribution List members Excel Worksheet Functions 1 April 7th 06 03:13 AM
Looking for function or formula to calculate number that is revers Ken Excel Worksheet Functions 2 February 7th 05 12:18 PM
How do you calculate the nth root of a number in Excel 2003? William Excel Worksheet Functions 2 November 17th 04 05:19 PM


All times are GMT +1. The time now is 12:56 PM.

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

About Us

"It's about Microsoft Excel"