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.

# EXEL 2003

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

### #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