Thread: #DIV/0 error
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default #DIV/0 error

All requests are handled the same way here. An URGENT request is sometimes
ignored.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"John" wrote in message
...
Guys i need URGENT help with this formula

i have 3 cells M62=M63/M64*100

now if both M63 and M64 are 0, I need M62 to display 0, but i know 0/0
gives
the DIV/0 error.

please let me know if there's a way around this.

Many Thanx
John