I have a sheet which tallies profit and loss in football matches. it works pretty well except for one thing. Some matches simply have no data for particular metrics; Over or Under 0.5 Goals as an example.
The cells which have no odds data come to me with N/A in them and it is throwing my calculations out.
So here is what I have
It basically checks if cell AU is blank and if not, performs the calculation. The problem is that every now and then, the cell in AU has N/A instead of a number and the result shows then as #VALUE!. This throws out any sum calculations on that column
How is it possible to include the ability to account for N/A in cell AU and simply output the result as a zero? I assume it will be something like adding
Thanks in advance for any help
The cells which have no odds data come to me with N/A in them and it is throwing my calculations out.
So here is what I have
=IF(AU7265<>"",IF(H7265>0,(AU7265-1)*1,-1),"0")
It basically checks if cell AU is blank and if not, performs the calculation. The problem is that every now and then, the cell in AU has N/A instead of a number and the result shows then as #VALUE!. This throws out any sum calculations on that column
How is it possible to include the ability to account for N/A in cell AU and simply output the result as a zero? I assume it will be something like adding
IF(AU7265="N/A","0","")
. Just unsure exactly where to put it so it does not affect anything else. I have tried inputting it in various locations, but get too many arguments entered when I do. I'm sure it will be some simple error in the syntax, but am not spotting itThanks in advance for any help