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

3 Replies

  • 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