Hiding duplicate formula results in a locked worksheet.

[iananddaph]

Hi,

I have a worksheet with 6 columns. (see attached file example)

I have protected the worksheet so that the column headed balance cannot be changed as this is where columns Amount Paid In and Amount Paid Out show via a formula into the Balance column but the Balance column needs the formula copied all the way down which shows the last Balance value all the way down the column.

How can I still have the formula copied down the column but not have the last balance value copied down the sheet when there are no values in Amount Paid in and Amount Paid Out.

Many thanks

Ian

[#2]

Hi Ian,

Try to update the formula as follows:

=IF(AND(B3="",C3=""),"",SUM(E2-C3+B3))

Using the functions IF and AND, you can build a logic to turn off the formula when the cells B3 and C3 are empty!

Hope that helps

@iananddaph

[#3 · Accepted solution]

@Haytham Amairah 

A very quick reply and a perfect outcome, 

many thanks

Ian