Ignore formula or ignore if QTY zero

[Mickyboro]

Hi,

I have expenses in cell E291 and I have managed to distribute these expenses across all the sections in the spreadsheet.

My issue is that the expenses is being spread when there is a QTY of 0. I have attached the sheet below and the formula as it is, as you can see in column Q it is still adding the expenses and spreading it across all rows even when the QTY is set to zero. Is there a way I can edit this formula to ignore it when the QTY in column F is at 0.

Really getting on my nerves this one now! ?

Thanks in advance!

 

[hrayani]

assuming your formula is starting from G6

=If(F6=0,"",$E$291 then type rest of your formula till the end