iserror with an isblank function together

[Hsanta]

so i have the following the that works great but as i drag the formula down I get a div/0 error on blank rows. How do I insert an iserror function into this so that if it errors the field is blank?

=SUM(IF(ISBLANK(C4),N4/L4,O4/C4))

 

[Joe4]

Welcome to the Board!

One way:
=IFERROR(SUM(IF(ISBLANK(C4),N4/L4,O4/C4)),"")

 

[Hsanta]

HA! first time ever posting for help and you delivered. THANK YOU!

 

[Joe4]

You are welcome.
Glad I was able to help!