excel 2007
=MAX(A1,3)
--
David Biddulph
"graham black" wrote in message
...
I need the formulae for
if cell A1 = 2.4 B1 = 3
A2 = 7.6 B2 = 7.6
want formulae for B1,B2 etc, in other word if the value is less than <3,
to
= 3, all other values 3 to record as that value
Can you please help?
--
GB
|