Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Amount Question
Hi there
I need a formula if column C2 has an amount 600 or above return a result of 1 If there's no number leave it blank or if the number is below 600 leave it blank as well Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Amount Question
Try this:
=IF(AND(ISNUMBER(C2),C2=600),1,"") -- Biff Microsoft Excel MVP "Killer" wrote in message ... Hi there I need a formula if column C2 has an amount 600 or above return a result of 1 If there's no number leave it blank or if the number is below 600 leave it blank as well Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Amount Question
Do you need the ISNUMBER test, Biff? Can it be =600 without there being a
number in the cell? -- David Biddulph "T. Valko" wrote in message ... Try this: =IF(AND(ISNUMBER(C2),C2=600),1,"") -- Biff Microsoft Excel MVP "Killer" wrote in message ... Hi there I need a formula if column C2 has an amount 600 or above return a result of 1 If there's no number leave it blank or if the number is below 600 leave it blank as well Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Amount Question
I've now realised that a cell with text representing a number greater than
or equal to 600 will satisfy the =test, but not the ISNUMBER test. So your formula draws that distinction. -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Do you need the ISNUMBER test, Biff? Can it be =600 without there being a number in the cell? -- David Biddulph "T. Valko" wrote in message ... Try this: =IF(AND(ISNUMBER(C2),C2=600),1,"") -- Biff Microsoft Excel MVP "Killer" wrote in message ... Hi there I need a formula if column C2 has an amount 600 or above return a result of 1 If there's no number leave it blank or if the number is below 600 leave it blank as well Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Amount Question
Also, consider the possibility that C2 contains a formula that might return
a blank. -- Biff Microsoft Excel MVP "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... I've now realised that a cell with text representing a number greater than or equal to 600 will satisfy the =test, but not the ISNUMBER test. So your formula draws that distinction. -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Do you need the ISNUMBER test, Biff? Can it be =600 without there being a number in the cell? -- David Biddulph "T. Valko" wrote in message ... Try this: =IF(AND(ISNUMBER(C2),C2=600),1,"") -- Biff Microsoft Excel MVP "Killer" wrote in message ... Hi there I need a formula if column C2 has an amount 600 or above return a result of 1 If there's no number leave it blank or if the number is below 600 leave it blank as well Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If two Columns have Data enter the Amount Question! | Excel Discussion (Misc queries) | |||
Question For Importing Data Into Excel/Converting General Number to Dollar Amount | Excel Discussion (Misc queries) | |||
Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
Does the title of the question effect the amount of replies I get. | Excel Discussion (Misc queries) |