IF Function

[Lizz45ie]

I have a complicated formula where I need to add a IF statement. I'v
included the formula for your review:

=(SQRT(((POWER(((C39+D39)/1000000),3.5)*(POWER(H39,10))/POWER(B39*F39,2)))))*100

I am trying to add the IF statement to the last portion of the formula
If 'F39' is blank I want the formula to skip calculating the last par
of the formula, but if
'F39' is populated then calculate (B39 * F39, 2).

Any help is appreciated

 

[Bearacade]

=if(isblank(f39),sqrt((power(((c39+d39)/1000000),3.5)*(power(h39,10))))*100,(sqrt(((power(((c39+d39)/1000000),3.5)*(power(h39,10))/power(b39*f39,2)))))*100)

Hth

 

[b o b]

I am not completely sure what you are considering the last part of the
formula. but you can use the following IF statement to determine if
cell F39 is blank and return 1 if it is blank and 0 if it is not.

=IF(F39="", 1, 0)

Hopefully you can apply this to your formula.