Multiplication formula gives DIV error.

[And180y]

Having a total brain freeze. my formula is =C11*E11*G6 Which gives me my answer in I11. G6 is a hidden Cell with the formula 365/G11 (G11 being a number of days) if the days are 0 I get a #DIV0! error. What am I missing to supress the error please?

[Greg M]

Hi there,

You could try:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

[And180y]

Hi Greg thanks for reply, I am getting a 0 for my answer in I11 when using above.
Sorry, to elaborate I get days not specified at 0 days but get 0 when I have 1 day and upwards.

[TMS]

That implies that C11 * E11 * G6 is giving you zero. Which means one of those cells is zero or blank.

[And180y]

Hi Trevor, thanks for answering. Yes G6 is G11/365 so both G11 and G6 could be blank/zero.

[TMS]

So, G11/365 is a small number. Try increasing the decimal places.

[TMS]

If the cells referred to are all equal to 1, the value returned by the formula is 0.002739726 which would display as zero at less than 3 decimal places.

[And180y]

Thanks Gregg and Trevor, sometimes it pays to "zoom out". Your advice was perfect, however my failure to step through what I was doing from the start instead of the end was the issue. :-)

[TMS]

You're welcome. Thanks for the rep.


Sometimes the obvious isn't that obvious

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M