I have a complicated formula where I need to add a IF statement. I've
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 part
of the formula, but if
'F39' is populated then calculate (B39 * F39, 2).

Any help is appreciated.


--
Lizz45ie


------------------------------------------------------------------------
Lizz45ie's Profile: http://www.excelforum.com/member.php...o&userid=23410
View this thread: http://www.excelforum.com/showthread...hreadid=552833

=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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=552833

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.


Lizz45ie wrote:
I have a complicated formula where I need to add a IF statement. I've
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 part
of the formula, but if
'F39' is populated then calculate (B39 * F39, 2).

Any help is appreciated.


--
Lizz45ie


------------------------------------------------------------------------
Lizz45ie's Profile: http://www.excelforum.com/member.php...o&userid=23410
View this thread: http://www.excelforum.com/showthread...hreadid=552833