Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF in combination with larger than
Hi,
cell C1 contains: =IF(A13,1,0) this obviously does not work, but how to achieve this? Thanks! tom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF in combination with larger than
You get a result of 1 or 0
Which result did you expect? Cheers, -- AP "tom ossieur" a écrit dans le message de news: ... Hi, cell C1 contains: =IF(A13,1,0) this obviously does not work, but how to achieve this? Thanks! tom |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF in combination with larger than
I don't know what you mean by " ... this obviously does not work ..."
Check that A1 is not formatted as text. If it is a number that is greater than 3 then cell C1 should return 1, otherwise 0. Is this what you want? Pete tom ossieur wrote: Hi, cell C1 contains: =IF(A13,1,0) this obviously does not work, but how to achieve this? Thanks! tom |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF in combination with larger than
hmmm... undoubtly the most stupid question i've ever posted... sorry and
thanks... seems i did something wrong... "Ardus Petus" wrote: You get a result of 1 or 0 Which result did you expect? Cheers, -- AP "tom ossieur" a écrit dans le message de news: ... Hi, cell C1 contains: =IF(A13,1,0) this obviously does not work, but how to achieve this? Thanks! tom |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF in combination with larger than
Obviously?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "tom ossieur" wrote in message ... Hi, cell C1 contains: =IF(A13,1,0) this obviously does not work, but how to achieve this? Thanks! tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop-down list Populated by a Subset of a larger list | Excel Worksheet Functions | |||
Help with Combination function | Excel Worksheet Functions | |||
Help with Combination Function | Excel Worksheet Functions | |||
How do I add a larger sized, blank every other row in a spread she | Excel Discussion (Misc queries) | |||
"combination drop-down edit " form activation in Excel | Excel Discussion (Misc queries) |