Share via

Isblank Formula

Anonymous
2023-01-24T01:17:45+00:00

I have the following formula:

=sum(q8-i8-j8-k8-l8-m8, offset(n8,-1,0))

I want to add isblank to the formula so I don’t get the #value error. 

Please help. Thank you.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-01-24T01:57:40+00:00

    Hi CarolF_001,

    I’m Daniel and I will be happy to help you with your question, I am a Microsoft consumer like you.

    You can add the ISBLANK function to the formula by wrapping it around the cells you want to check for blank values.

    For example: =SUM(IF(ISBLANK(q8),0,q8)-IF(ISBLANK(i8),0,i8)-IF(ISBLANK(j8),0,j8)-IF(ISBLANK(k8),0,k8)-IF(ISBLANK(l8),0,l8)-IF(ISBLANK(m8),0,m8),OFFSET(n8,-1,0))

    This will check if each cell is blank and if it is, it will return 0 instead of a value, which will prevent the #VALUE! error from occurring.

    I hope this information helps. If you have any questions, please let me know and I'll be glad to assist you further.

    Best Regards,

    Daniel

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments