Leave final cell blank



With the formula below S3 is populated with the correct answer.


However when i C&P this formula into S4 i get #Value! because cells B4 thru
R4 are empty. How can i change the above formula so S4 remains blank if no
figures are entered into cells B4 thru R4?


Above is not quite right.

In the equation set out in S4 all other cells thru C4 thru R4 are empty but
b4 has a value in it.

Jacob Skaria

Try the below...
'if you have only +ve numbers

'if you have negative numbers

If this post helps click Yes

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question