Using IF formula

[Blackspear]

=IF(J3=0,"",J3/H3)

What if cell H3 and/or J3 is zero, what formula do I need to stop #Div/0! and #value ???

 

[Legacy 98055]

=IF(AND(J3<>0,H3<>0),J3/H3,"")

<pre>

If J3 does not = 0 and
H3 does not = 0 then J3/H3

Else ""

</pre>

Tom

 

[Aladin Akyurek]

On 2002-04-27 22:45, Blackspear wrote:
=IF(J3=0,"",J3/H3)

What if cell H3 and/or J3 is zero, what formula do I need to stop #Div/0! and #value ???

=IF(H3,J3/H3,"")

 

[Blackspear]

Many thanks Tom One more for you, a simple one I have 100 and the cell next to it I need 5% of 100

Cheers

Craig.

 

[Aladin Akyurek]

I have 100 and the cell next to it I need 5% of 100

=A1*5%

where A1 has either a number or empty.

 

[Aladin Akyurek]

On 2002-04-27 23:09, Aladin Akyurek wrote:

On 2002-04-27 22:45, Blackspear wrote:
=IF(J3=0,"",J3/H3)

What if cell H3 and/or J3 is zero, what formula do I need to stop #Div/0! and #value ???

=IF(H3,J3/H3,"")

By the way, you get a #VALUE! error only if H3 and/or J3 contains a text value like "abc".

The above formula will suffice when it's guaranteed that these cells will not have such text values while either one or both can be truly empty.

 

[Blackspear]

Aladin, thank you so much, been a great help, easy to do on a calculator, not so easy in excel with formula's

Craig.