ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW DO I SHOW A ZERO VALUE FOR A FORMULA THAT RETURN A " FALSE" ? (https://www.excelbanter.com/excel-discussion-misc-queries/110032-how-do-i-show-zero-value-formula-return-false.html)

vijay

HOW DO I SHOW A ZERO VALUE FOR A FORMULA THAT RETURN A " FALSE" ?
 
HOW DO I SHOW A ZERO VALUE FOR A FORMULA THAT RETURN A " FALSE" ?

Bernard Liengme

HOW DO I SHOW A ZERO VALUE FOR A FORMULA THAT RETURN A " FALSE" ?
 
Are you going to let us know the formula or shall we guess?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"vijay" wrote in message
...
HOW DO I SHOW A ZERO VALUE FOR A FORMULA THAT RETURN A " FALSE" ?




MyVeryOwnSelf

HOW DO I SHOW A ZERO VALUE FOR A FORMULA THAT RETURN A " FALSE" ?
 
HOW DO I SHOW A ZERO VALUE FOR A FORMULA THAT RETURN A " FALSE" ?

One way:
=N(your_formula)


All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com