Forum Discussion

asi weis's avatar
asi weis
Copper Contributor
Jan 16, 2018

If Function

Hello  I'm receiving an error message while using the formula:   =IF(O7=0,"",P7/O7), when column P is empty. It worked great on excel 2010 but not on excel 2016.   Any idea? 
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 16, 2018

Hi asi,

 

is your data in column P is copy/pasted from some external source or it was entered only manually from scratch?

asi weis's avatar
asi weis
Copper Contributor
Jan 16, 2018

Hi Sergei

 

It is copy / pasted from an external source. 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 16, 2018

    When most probably unprintable characters are in you cells. Perhaps the easiest way is something like

    =IFERROR(P7/O7,"")

     

Resources