#division/0!

[candlelights]

How do I receive (N/A) in this case ?

[TABLE="width: 500"] <tbody>[TR] [TD]	A	B	C	D
1	Brand	month	month2
2		SEPT 18	OCT 18	DIFF (%)
3	AUDI	0	150	=C3/B3-1

<tbody>
</tbody>

[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]This returns: #DIVISION/0! in D3.
How can I get a (N/A) instead ?
Some kind of (IF) function, but I cant get ir right [/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[BarryL]

how about:

=IFERROR(C3/B3-1,NA())

 

[AlanY]

you can put whatever message within the " " marks

=IFERROR(C3/B3-1,"…")

 

[candlelights]

Sorry bu I still get the: #division/0!

 

[BarryL]

If you are getting #DIV/0! and you have wrapped it correctly in an IFERROR, it cannot show #DIV/0!.

Can you post the exact formula you put in your worksheet?

 

[candlelights]

Problem solved !
Thanks

 

[Joe4]

Just note that IFERROR will capture ALL errors, not just the division by 0 errors.
If you want to be sure to limit it to just the division by zero answers, use this instead:

[COLOR=#333333]=IF(B3-1=0,NA(),C3/B3-1)[/COLOR]