Cell B24 has a formula in it that will sometimes populate a number based on how the spreadsheet is filled out. Cell B26 has a simple formula in it: sum(365/B24) so whatever number populates in

Cell B24 has a formula in it that will sometimes populate a number based on how the spreadsheet is filled out.

Cell B26 has a simple formula in it: sum(365/B24) so whatever number populates in cell B24, it does 365 divided by that number.

Here is the puzzle. Sometimes the formula in B24 does not generate a number. When this happens, I just want cell B26 to calculate 365 divided by whatever number I manually type into cell B25.

I know some about sum, if and sumif. I tried the formula below, as well as a few variations, but no luck. Hope someone out there knows.

=IF(B24>0,SUM(365/B24)),IF(B24=””,SUM(365/B25)

ATTACHMENT PREVIEW

Download attachment

Inventory Turnover
Err:510
COGS/Inventory
400
Days Sales in Inventory
Err:509
365 days/Inventory Turnover

Leave a Comment