Thread: excel 2007
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
graham black graham black is offline
external usenet poster
 
Posts: 1
Default 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