dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,352
- Office Version
- 365
- 2016
- Platform
- Windows
I have a formula. If the result is an error, how do I make a 0 appear?
I tried this but it won't work
Excel Formula:
=IF(E5="Activities",0,[Price
ex. GST]*0.1)
I tried this but it won't work
Excel Formula:
=IFERROR(IF(E5="Activities",0,[Price
ex. GST]*0.1),0)