janema
Board Regular
- Joined
- Nov 28, 2022
- Messages
- 117
- Office Version
- 365
- 2021
- 2019
- 2011
- 2010
- Platform
- Windows
- Mobile
I am just having the worst time with getting formulas to work today
In column AC, I am just trying to get the formula to return BLANK if it is an error or there is no data in column Z (or if result is zero). But I keep getting an error message that there are too many arguments.
My formula is currently:
=IF((Z4/X4)=0,"","",IFERROR(Z4/X4),"", Z4/X4))
In column AC, I am just trying to get the formula to return BLANK if it is an error or there is no data in column Z (or if result is zero). But I keep getting an error message that there are too many arguments.
My formula is currently:
=IF((Z4/X4)=0,"","",IFERROR(Z4/X4),"", Z4/X4))