If then or?

**Benn5784** · 08-12-2018, 05:54 PM

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

**Pete_UK** · 08-12-2018, 06:00 PM

If you divide a number by itself the result is 1. I'm not sure what you are trying to do.

Pete

**jtakw** · 08-12-2018, 06:14 PM

Hi,

If you want to SUM Row 1 when corresponding Row 2 is Not Text or 0 (zero), use E1 formula, if Row 2 zero is to be included, then use E4 formula:

Excel 2016 (Windows) 64 bit