ExcelBanter - If Formula

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - If Formula (https://www.excelbanter.com/excel-programming/374281-if-formula.html)

ShamsulZ

If Formula

Can anybody help me in the if formula whereas if the cell has no value it
will show a in another cell, if has any value it will show b in the another
cell

Thanks

Stefi

If Formula

Say the cell to be checked is A2, enter into the "another" cell
=IF(ISBLANK(A2),"a","b")

Regards,
Stefi

€žShamsulZ€ ezt Ã*rta:

Can anybody help me in the if formula whereas if the cell has no value it
will show a in another cell, if has any value it will show b in the another
cell

Thanks

All times are GMT +1. The time now is 04:26 PM.