Formula

C

caz01

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

Andy Brown

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
 
B

Bob Phillips

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.
 
B

Bob Phillips

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

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

Copy addition formula of non-consecutive horizontal cells 2
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Autonumber field in Excel that behaves the same as Access 0
Percentage of month passed formula 1
How can i find the max value within a time range ased on two cells 6
Display weeks from a Milestone 0
Modify Print to One Note driver 0
Formula to equal a maximum of 100% 3

Top