Formula with OR function.

[sachar]

Dear All,

With reference to the attachment the column “I” is not getting the result of “y” always in case of [column”G”] equal to the percentage 17.4% or 9.0%.

Please help me to correct.

 

[vletm]

How many 'y' do You could get?
How many values are equal to 17,4% or 9,0%?

 

[sachar]

Dear Vletm,

Received with thanks, I agreed with you, but, what can I do to get the exact % value in column "G"?

 

[vletm]

You could use ROUND-function.
like =IFERROR(ROUND(F5/C5;4))

 

[sachar]

Dear Vletm,

Many.... Thanks.

 

[bosco_yip]

Maybe,

In G5, copy down :

=IF(C5,ROUND(F5/C5,3),"")

Regards