NEED TO CREATE A CONDITIONAL FORMULA

S

SB

Hello I need to create a conditional formula that will select ONLY the cell
with the greatest value. So... I have a series of cells with values and I
want to populate another cell using a formula that will be the greatest value
only.

CAN you please help..... Thank you
 
K

Kevin Vaughn

I may be missing something, but don't you just want the max function?
=max(a1:a10)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Drop down list control value in vba 2
Conditional Formatting Amendment 2
calculating volatility 0
Excel - Wich Function should I use? 1
Copy addition formula of non-consecutive horizontal cells 2
Autonumber field in Excel that behaves the same as Access 0

Top