4400 165
6.5 NOF
If Cell A2 is a number I want to divide by itself and multiply by cell A1, then I want to do the same for column 2 and sum the total but if cell B2 is not a number or equal to zero as shown here I'm not able to divide by itself and the formula returns an error. Help?
The result of this table should be (6.5/6.5*4400)+(NOF/NOF*165) = 4400
Bookmarks