if function and iferror function

[07312]

hi!
i wish someone could help me. i have problem with a cell (actually F11) with the formula =if(E11>=0.75,"mastered",if(E11>=0.25,"nearly mastered",if(E11>=0,"least mastered","")))
and the formula in cell E11is =iferror((D11/C11),""). my problem is that when ever E11 is in error the value in F11 is "mastered", why is F11 not blank. . i'm expecting it to be blank if E11 is in error. . please help!

 

[shaowu459]

=IF(E11="","",if(E11>=0.75,"mastered",if(E11>=0.25,"nearly mastered",if(E11>=0,"least mastered",""))))

 

[07312]

the value of cell d11 and c11 are currently blank

 

[Joe4]

Two ways:

Change the formula in F11 to:

=IF(E11="","",IF(E11>=0.75,"mastered",IF(E11>=0.25,"nearly mastered",IF(E11>=0,"least mastered",""))))

- or -

Change the formula in E11 to:

=IFERROR((D11/C11),-1)

then F11 will return what you want.

 

[07312]

thank you so much guys that was fast! i really appreciate it!!!now my problem is solve. . thanks and God bless!

 

[Joe4]

You are welcome.
Glad we were able to help!