Nested IF function to ignore blank cells

[Ralley]

Hi,

I am currently using the following formula, but due to the size of the spreadsheet now I would to drag the formula down the page without it populating the rows that are blank. Please can anyone help?

=IF(O10="",X10,IF(X10="",O10+Q10+S10))

Cheers

Richard

 

[Ralley]

=IF(A10<>"",O10+Q10+S10+U10+Z10,"")

HTH

I think thats what you mean, can you clarify further if example above doesnt give you what you need.

Brilliant!! This is exactly what I needed, thankyou. I can link all my formulas to the reference cell now.

Thank you both for your time on this.

 

[Mr.Daines]

No problem, hopefully someone might be able to help me on my post lol.