Return False Formula (somewhat complicated)

[ScottTemple]

Hello,

I have the following formula in cell T2: IF(E2),IF(F2),IF(R2),((F2)*4)/(R2*(E2)^)/12))

However, when the value in R2 is either a blank or a 0, I get either a #DIV/0 or #VALUE error. I would ideally like to return a FALSE value in cell T2.

 

[Joe4]

You have at least one error in the calculation part of your formula (no number after the "^").
When you get that corrected, try a formula structured like this:

=IF(AND(E2<>0,F2<>0,R2<>0),your corrected calculation formula,FALSE)

 

[ScottTemple]

You have at least one error in the calculation part of your formula (no number after the "^").
When you get that corrected, try a formula structured like this:

=IF(AND(E2<>0,F2<>0,R2<>0),your corrected calculation formula,FALSE)

I'm unable to get that formula to work, can you verify if the FALSE is in the right location on my formula below:

IF(AND(E2<>0,F2<>0,R2<>0),((F2)*4)/(R2*(E2)^)/12),FALSE))

 

[awoohaw]

You did not fix the error that was pointed out @Joe4 . see what is underlined below:
IF(AND(E2<>0,F2<>0,R2<>0),((F2)*4)/(R2*(E2)^)/12),FALSE))
you need a number after the ^ and before the ).

 

[ScottTemple]

You did not fix the error that was pointed out @Joe4 . see what is underlined below:
IF(AND(E2<>0,F2<>0,R2<>0),((F2)*4)/(R2*(E2)^)/12),FALSE))
you need a number after the ^ and before the ).

Must have accidently deleted that when I pasted it over, there should be a 2 there.

IF(AND(E2<>0,F2<>0,R2<>0),((F2)*4)/(R2*(E2)^2)/12),FALSE))

 

[awoohaw]

you have some misplaced and unnecessary parentheses:

Book1
	E	F												R		T
1
2	2	3												4		0.0625
Sheet5

Cell Formulas
Range	Formula
T2	T2	=IF(AND(E2<>0,F2<>0,R2<>0),((F2)*4)/(R2*(E2)^2)/12,FALSE)

If that isn't the formula you want processed. Remove the error checking IF statement and rebuild the formula with all conditions good. Then wrap the error around the corrected formula.

 

[ScottTemple]

My apologies, I don't know what I did when I inputted that first formula. I've copied it again in full below, I was missing divide by pi:

IF(AND(F2<>0,H2<>0,R2<>0),(((H2*4)/3.14)/(R2*(F2^2)))/12)

 

[awoohaw]

so, is it still wrong? If so, build the formula with TRUE conditions in cells F2, H2, and R2. when you get that working. Then put the IF and AND statements in.

 

[ScottTemple]

Lol that worked, just didn't plug it into my sheet, thank you!

 

[awoohaw]

Happy to help.

Best wishes!