IF/OR Function

[Getfothers]

I want to neaten up my spreadsheet, I was trying to get a function that would do

If Cell H7 & Cell H8 are both empty, then display nothing
If Cell H7 or H8 contain any number then run (=K7+H7-H8)

essentially the spreadsheet add a running total in column K, but I want to hide the output below where we are currently working.

regards
Ian

[Getfothers]

I wanted to attache a screen dump to better explain what I was trying to achieve. Under the $500 credit the result $495 continues all the way down the page. I want to hide that until I enter another amount. Hope that clarify s
regards Ian

[NBVC]

Try:

=IF(Countblank(H7:H8)=2,"",K7+H8-H7)

[Getfothers]

Try:

=IF(Countblank(H7:H8)=2,"",K7+H8-H7)

Thanks I changed it to this and it worked perfectly

=IF(COUNTBLANK(H7:I7)=2,"",K6-H7+I7)

I assume the countblank 2 mean if both cell are empty and if i was checking 3 cells I would change that to 3?

regards
Ian

[NBVC]

I assume the countblank 2 mean if both cell are empty and if i was checking 3 cells I would change that to 3?

regards
Ian

Yes, correct