#DIV/0 error how to hide

[jaiD]

Hi how do i hide as blank or show as 0 or something if a calculation is unable to take place. for example.

a1 = 2
a2 = 4

i am doing a calculation to work out the % which is =a4/a2 which equals 50%.

but when the following happens

a1 = 0
a2 = 0

i get the following result #div/o i don't want it to show this but instead be blank or show 100% or 0%

 

[immyjimmy]

Greetings.

I'd use something like:

=IF(ISERR(C28/C29),"ERROR",C28/C29)
or
=IF(ISERR(C28/C29),"",C28/C29)
if you didn't want anything to show...

HTH,
Jim

 

[JLouis]

Hello!

Use conditional formatting to change the font color to the same color as the worksheet. The DIV/#0 will still be there but not visible.

I've seen some very good posts regarding conditional formatting. Try a search for this.

 

[Aladin Akyurek]

=IF(A2,A4/A2,0)

=IF(N(A2),A4/A2,0)

 

[jaiD]

Think I may encounter problems with this as the following is the data

I need it to say 100% if the following

Submitted Pass Fail
1 1

& if the following i want it to say 0%

Submitted Pass Fail
1 1

& if the following i want it to say 50%

Submitted Pass Fail
2 1


submitted column is A
Pass is B
Fail is C

 

[Aladin Akyurek]

Think I may encounter problems with this as the following is the data

I need it to say 100% if the following

Submitted Pass Fail
1 1

& if the following i want it to say 0%

Submitted Pass Fail
1 1

& if the following i want it to say 50%

Submitted Pass Fail
2 1


submitted column is A
Pass is B
Fail is C

What if Submitted = 2 and Fail = 1?

 

[jaiD]

yes sorry the figures should have had a space between them with 1 being under submitted and 1 under fail etc...