View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Set value to zero when result is 0 otherwise show actual value

Try this in C1:

=IF(A1=0,0,B1/A1)

Hope this helps.

Pete

On May 5, 10:31*am, TSK wrote:
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