Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

EXEL 2003


  • Please log in to reply
2 replies to this topic

#1 RD2005

RD2005

  • Members
  • 29 posts
  • OFFLINE
  •  
  • Local time:07:23 AM

Posted 06 June 2005 - 12:01 PM

I HAVE A FOUR PERIOD COMPARATIVE INCOME STAETEMENT.
CELLS WITH DIFEERENT SALES FIGURES ARE A1,A3,A5,A7. BESIDE EACH OT THE SALES NUMBER ,I HAVE IN A2,A4,A6,A8 THE % OF SALE

I WANT CELL A9 TO RESULT IN THE LARGEST SALE NUMBER OF THE FOUR SALES FIGURES.

NOTE IN THE SAME WORKBOOK (IN CELL A10)I HAVE BEEN ABLE TO PRODUCE A RESULT WITH A FORMULA FOR THE LOWEST%

HOWEVER THE LARGEST SALE NUMBER FOR A9 COME UP WITH THE POP UP WINDOW THAT STATES AN ERROR IN THE FOMULA (i'M USING THIS FORMULA FOR A9)
=LARGE(A2,A4,A6,A8)

wHY IS THIS HAPPENING

BC AdBot (Login to Remove)

 


#2 jgweed

jgweed

  • Members
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:06:23 AM

Posted 06 June 2005 - 12:08 PM

Why not use the MAX function for the range in question? It will return the largest values in a user set.
Regards,
John
Whereof one cannot speak, thereof one should be silent.

#3 RD2005

RD2005
  • Topic Starter

  • Members
  • 29 posts
  • OFFLINE
  •  
  • Local time:07:23 AM

Posted 06 June 2005 - 01:00 PM

Thanks that worked.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users