Hello,
I know this is probably something simple but I cannot figure it out. I need the formula in cell H4 to return 0.00 instead of #Value if no data is selected from dropdown on Matrix tab and no data is entered in D4:G4 on Tab 1.
On tab 1, cell O2 returns the value from dropdown list in cell H3 of Matrix tab. If nothing selected in cell H3 of Matrix tab, then cell O2 remains blank on tab 1. However, if there is a selection made from the dropdown list in cell H3 of Matrix tab, it will show in cell O2 of tab 1.
Cell H4 of tab 1 should calculate: =SUM(D4:G4)/O2
If nothing is in cell O2 of tab 1, H4 needs to show 0.00 instead of #Value. Same for cell H7.
What am I missing in my formula?
Thanks in advance for your assistance. It is greatly appreciated.
Bookmarks