G
Guest
How do i enter a preset maximum, i have a formula which i do not want to exceed 15.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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)
=MAX(15,your_formula)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
exceed 15.caz01 said:How do i enter a preset maximum, i have a formula which i do not want to
R
Ragdyer
I'm sure Bob, that what you *really* meant was:
=MIN(15,your_formula)
=MIN(15,your_formula)
B
Bob Phillips
Course I did, thanks!
Bob
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 !
-------------------------------------------------------------------------- -