Thread: IF Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lizz45ie
 
Posts: n/a
Default IF Function


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