Help with data ranges

  • Thread starter Thread starter RRALICIA
  • Start date Start date
R

RRALICIA

I'm trying to create a sheet that puts data I want into a cell. The problem I'm
having is that I want to assign a maximum number to return. For example:

if A1= 5
multiplied by B1=4

my sum in B10= 20. I can only use 18. How do I make that sum return a maximum
number of 18? The range of numbers I can use is 1 through 18 only.

Thanks, Rob
 
Use MAX

=MAX(18, A1*B1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top