ExcelBanter - Excel Formula

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

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

- - Excel Formula (https://www.excelbanter.com/excel-discussion-misc-queries/243790-excel-formula.html)

Brent

Excel Formula

How do I create a formula for a blank cell to equal the word NO?

Thanks!

Dave Peterson

Excel Formula

So if A1 is the cell, then an empty cell or No means No?

=if(or(a1="",a1="no"),"it's equivalent to no","it's something else")

Brent wrote:

How do I create a formula for a blank cell to equal the word NO?

Thanks!

--

Dave Peterson

All times are GMT +1. The time now is 08:43 PM.