Rounding & IF statement Question

I am using IF statements with all 7 variables in it. I am trying to get the statement to look at the answer from another cell, which it is. The problem is the cell it is pointing to has an answer like 3.9375 (I have the cell showing no decimal placing, so 4) and I cannot get the If statement to use the rounded number.

The answer will never be the same unless rounded, so I cannot just use the 3.9375.

Here is my IF statement:
=IF(E10/E16="XXX", "", IF(E10/E16=1, 1, IF(E10/E16=2, 3, IF(E10/E16=3, 6, IF(E10/E16=4, 10, IF(E10/E16=5, 15, IF(E10/E16=6, 21, IF(E10/E16=7, 28, "XXX"))))))))

I this case E10 is 1,778 and E16 is 7,000. But both those values will change.

I have the answer from E10/E16 in another cell, again rounded with no decimel points, I tried to point to that (E18) again without luck.

Thanks for your help!

I'm not sure how E10/E16 can ever equal "XXX", perhaps try

=IF(E16,(ROUND(E10/E16,0)^2+ROUND(E10/E16,0))/2,"")

Originally Posted by daddylonglegs

I'm not sure how E10/E16 can ever equal "XXX"

You guys are quick!

I only does before the information is put in. I am making a program to calculate how many pounds per square foot a cement block can handle, and then how many blocks we would need for X amount of weight.

XXX represents a cell waiting for numbers to be put in, I just didn't want anything in the results cell before the other cells are filled.

I will try to add the round function, but I've never used that before. What does the zero do in this --> (E10/E16,0)?

Thanks again!