Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i enter a preset maximum, i have a formula which i do not want to exceed 15.
 
How do i enter a preset maximum, i have a formula which i do not want to
exceed 15.

A little short on detail. Let's say you have

=A1*2

in B1. You could use Data -- Validation for A1 (Allow = Custom, Formula
=B1<=15).

HTH,
Andy
 
How about

=MAX(15,your_formula)

--

HTH

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

caz01 said:
How do i enter a preset maximum, i have a formula which i do not want to
Click to expand...
exceed 15.
 
I'm sure Bob, that what you *really* meant was:

=MIN(15,your_formula)
 
Course I did, thanks!

Bob

Ragdyer said:
I'm sure Bob, that what you *really* meant was:

=MIN(15,your_formula)
--
Regards,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -
Click to expand...
 
You must log in or register to reply here.

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

SUMDIVISION formula function - does it exist? 6
Formula/Function for Counting Characters in a cell 4
Automatically Entering Values 3
Validate a total of a row 1
I want a value hidden if it is 0 2
Formula to equal a maximum of 100% 3
Conditional formatting for values in a column that exceed a set limitwhen summed 4
Using IF statements in conjunction with other function 1

Back
Top