excel 2007
 

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

excel 2007
 

Hi Graham

Try
=MAX(3,A1)

--

Regards
Roger Govier

"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

excel 2007
 

Hello Graham

In B1 and copied down:

=IF(A1<3,3,A1)

Richard


On 30 Nov, 11:21, graham black
wrote:
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

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

excel 2007
 

For B1:
=MAX(3,A1)
and copy down column B as far as required.

Or, if you want nothing to show in B1 until there is something in A1:
=IF(A1="","",MAX(3,A1))

"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