| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if command for yes or no
how can I get a worksheet to answer Y or N for a column.
For example column I5 is greater then H5 i want a Y or N on column J5. Any help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if command for yes or no
On Tue, 15 Nov 2005 11:26:11 -0800, "Henry"
wrote: how can I get a worksheet to answer Y or N for a column. For example column I5 is greater then H5 i want a Y or N on column J5. Any help? =IF(I5H5,"Y","N") --ron |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if command for yes or no
In J5 enter formula:
=if(I5H5,"Y","N") "Henry" wrote in message ... how can I get a worksheet to answer Y or N for a column. For example column I5 is greater then H5 i want a Y or N on column J5. Any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
