#NUM! Error 2

[grendal]

HI,
I've a formula as follows:-
=([JANSALES]-[JANCOST])/[JANSALES]
This caluculates the profit margin on a Sales report. However when faced with either or both fields containing zero's - I get the #NUM! error. Is there a way around this.

Cheers s-)
Some girls mothers are bigger than other girls, mothers. (The Smiths)

 

[TheAceMan1]

Hiw are ya grendal . . . . .

[ol][li]What do you want the field to show if [blue]JANSALES[/blue] = 0 ? (divisor = 0)[/li]
[li]If [blue]JANCOST[/blue] = 0 the equation returns [purple]1[/purple]. Do you want to show [purple]1[/purple] or something else?[/li][/ol]

See Ya! . . . . . .

 

[PHV]

You may try to play with the IIf function:
=IIf([JANSALES]=0, 0, ([JANSALES]-[JANCOST])/[JANSALES])


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[grendal]

Whoops - forgot to say thanks. Great tips!

Cheers s-)
Some girls mothers are bigger than other girls, mothers. (The Smiths)