ExcelBanter - pethow do i insert a Yes/No function into a cell in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - pethow do i insert a Yes/No function into a cell in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/45354-pethow-do-i-insert-yes-no-function-into-cell-excel.html)

petethomson

pethow do i insert a Yes/No function into a cell in Excel?

How do i insert a Yes/No function into a cell in Excel?

Paul Sheppard

petethomson Wrote:
How do i insert a Yes/No function into a cell in Excel?

Hi pete

Try an If function eg IF(A1=10, "Yes","No"), this is saying if A1 = 10
return the value Yes, if not return No

--
Paul Sheppard

------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=467552

All times are GMT +1. The time now is 05:35 PM.