#DIV/0 error
"John" wrote:
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.
=if(M64=0,0,M63/M64*100)
Never mind about M63 being zero. The formula will handle that just fine.
----- original message -----
"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
|