Thanks:  0
Likes:  0

1. =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 ???

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

```

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

Else ""

```

Tom

3. 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,"")

4. 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.

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

=A1*5%

where A1 has either a number or empty.

6. 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.

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

Craig.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•