Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
import excel 2007 in outlook 2007 | Excel Discussion (Misc queries) | |||
How can you "save as" in excel 2007 (and word 2007)? | Excel Discussion (Misc queries) | |||
Exporting Quickbooks 2007 to Excel 2007 | Excel Worksheet Functions | |||
Problems with my links to an excel 2007 file from a word 2007 file | Links and Linking in Excel |