dividing (1 Viewer)

Dona

Registered User.
Local time
Today, 20:00
Joined
Jun 27, 2002
Messages
55
I want to divide d8/b8; however in some cases d8 might be 0 or b8 might be 0. If either d8 and b8 = 0, I want a dash.

Found solution:

=IF(ISERROR(d8/b8),"-",d8/b8)
 
Last edited:

Users who are viewing this thread

Top Bottom