Doubt in Excel formula

[gopdeep]

If am having formula like below in "F6" cell, it is showing result as expected. But if both D6 & E6 cells are blank it is showing like #DIV/0! - here pls let me know that how can i hide the formula if it doesn't return values.

=D6/(D6+E6)*100

 

[VoG]

Try

=IF(AND(D6="",E6=""),"",D6/(D6+E6)*100)

 

[pgc01]

Hi

To avoid the division by 0 error, try:

Try

=IF(D6+E6=0,"",D6/(D6+E6)*100)

 

[gopdeep]

yep... its working

 

[gopdeep]

Hi... if D6 and D7 are provided with "0" then the resultant value should be 8... however formula =IF(D6+E6=0,"",D6/(D6+E6)*100) is showing empty cell, likewise formula =IF(AND(D6="",E6=""),"",D6/(D6+E6)*100) showing #DIV/0! as result. However i would like to get "0" as my result and also formula should be hidded if there is nothing? pls help me

</SPAN>

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>

 

[Mindpsyche]

Hi... if D6 and D7 are provided with "0" then the resultant value should be 8... however formula =IF(D6+E6=0,"",D6/(D6+E6)*100) is showing empty cell, likewise formula =IF(AND(D6="",E6=""),"",D6/(D6+E6)*100) showing #DIV/0! as result. However i would like to get "0" as my result and also formula should be hidded if there is nothing? pls help me

</SPAN>

<TBODY>
</TBODY>

Try this: And also lookup the If function and And function in Excel to help you out.

=if(and(D6="",E6=""),"",if(D6=0,0,if(and(D6>0,E6<>"",D6/(D6+E6)*100))