Make an =if show - instead of 0

[Guest]

='Accounts Payable'!L3

I want this formula to show - if it is "0" .
The Accounts Payable L3 is also a formula.
Is an if error required?

Thanks for any help.

 

[Ron de Bruin]

Hi Cube

You can use IF

=IF('Accounts Payable'!L3=0,"-",'Accounts Payable'!L3)

 

[Coolboy55]

Couldn't you just format the target cell as Accounting number type?

 

[Guest]

An alternative to Ron's suggestion is to format the cell using Currency or
Accounting formats. These still leave the cell's value as zero, but display
a hyphen.