Thread
:
Set value to zero when result is 0 otherwise show actual value
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
TSK
external usenet poster
Posts: 21
Set value to zero when result is 0 otherwise show actual value
Cell C1 - Reflect 0 or actual number different after b/a
When cell A1 - 0
When cell B1 - 0
Then cell C1 = 0 instead of #DIV/0!
When cell A1 - 5
When cell B1 - 100
Then cell C1 = 20
Reply With Quote
TSK
View Public Profile
Find all posts by TSK
Set value to zero when result is 0 otherwise show actual value