| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If
How do I get a return of 1 in column B for all numbers in column A that are
greater than 0? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If
=If(A10,1,"")
Copy down as needed. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Trace" wrote: How do I get a return of 1 in column B for all numbers in column A that are greater than 0? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If
Hi,
=if(A10,1,"") "Trace" wrote: How do I get a return of 1 in column B for all numbers in column A that are greater than 0? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
